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
Ads
Subscribe to:
Post Comments (Atom)
-
ERROR: report server remote procedure call (RPC) end point. Verify that the Report Server Windows service is running, and then retry the o...
-
Error messages: · The process could not execute 'sp_repldone/sp_replcounters' on ' SCKNLSSI '. (Source:...
-
Error Message: Replication-Replication Distribution Subsystem: agent DBA\DBA-EPDW-EPDW-DB6C\DB6C-5 failed. The subscription(S) have been...
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