March 27, 2012 at 9:03 am
Hi,
My Database is running in Sql server 2008 R2, I am taking backup of all my user database(sharepoint database) in the night. All database backup went well, except one database. Getting following error:
"Backup detected log corruption in database WSS_Content_8d4c986f-42d6-486c-a42f-9612a94620d9. Context is Bad Middle Sector. LogFile: 2 'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\WSS_Content_8d4c986f-42d6-486c-a42f-9612a94620d9_log.LDF' VLF SeqNo: x855 VLFBase: x32d80000 LogBlockOffset: x32e72000 SectorStatus: 4 LogBlock.StartLsn.SeqNo: x855 LogBlock.StartLsn.Blk: x730 Size: xe400 PrevSize: xe600"
Could anyone help me to fix this error permanently.
Gans
March 27, 2012 at 9:10 am
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
March 28, 2012 at 5:06 am
This was removed by the editor as SPAM
March 28, 2012 at 9:46 am
Thanks!
April 30, 2012 at 3:08 am
May be inaccessible file is corrupt or damaged but you can fix that error easily. I was also doing the same and some of my files were also not accessible but I applied a professional tool which fixed SQL errors and helped me to access them. You can visit here: http://tech.groups.yahoo.com/group/repaircorruptmdffiles/[/url]
May 3, 2012 at 3:56 am
This was removed by the editor as SPAM
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply