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
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