Follow the following steps,
1. Stop all user activity in the database
2. Switch to the SIMPLE recovery model (breaking the log backup chain and removing the requirement that the damaged portion of log must be backed up)
3. Switch to the FULL recovery model
4. Take a full database backup (thus starting a new log backup chain)
5. Start taking log backups
http://www.sqlskills.com/BLOGS/PAUL/post/How-can-a-log-backup-fail-but-a-full-backup-succeed.aspx
-
Find More On : - http://www.sqlserver-training.com/250-sql-queries-interview-question-answers/-#5+ SQL Queries Interview Questions ...
-
ERROR: report server remote procedure call (RPC) end point. Verify that the Report Server Windows service is running, and then retry the o...
-
http://technet.microsoft.com/en-us/library/cc731002(WS.10).aspx#BKMK_requirements How accounts are created through wizards in ...
Great stuff thanks for sharing! As i found another helpful post for the same see here: http://www.sqlmvp.org/backup-detected-corruption-in-the-database-log/
ReplyDeleteIf a transaction is aborted prior to completion, the database continues to remain in a consistent state as no trace of the aborted transaction would be available in the database.kpi dashboards
ReplyDeleteThank YOu!
Delete