Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Backup detected log corruption in database Expand / Collapse
Author
Message
Posted Wednesday, January 22, 2014 1:36 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, April 25, 2014 1:50 PM
Points: 49, Visits: 336
Last week we had some databases with a corrupt transaction log files. This happenend while our SAN operators were moving de databases to a new SAN (which didn't go well this time, although we took SQL Server offline first).

I have resolved the problems with the help of the article below (thanks Gail):
http://www.sqlservercentral.com/Forums/Topic733084-266-1.aspx

I detected the corrupt logfiles, because the log backups where failing with the error "Backup detected log corruption in database".

DBCC CHECKDB didn't warn me.

How can I check if my transaction logs are OK, because for databases that are using the Simple recovery model, you don't run a log backup.

This week I failed the instance to another node and I discovered that the log of the master database was corrupt. So I had to rebuild and restore the master to get my SQL server up and running again. Master is using the simple recovery model, so how could I have known it's log was corrupted?

Regards,
Marco
Post #1533821
Posted Monday, January 27, 2014 11:59 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Friday, October 24, 2014 11:52 AM
Points: 9,294, Visits: 9,484
Actually, I just had the same thing happen to me over the weekend, and I had the same question: short of BACKUP LOG, is there some way that I can check the integrity of the Transaction Log file(s) for my databases?

Thx.


-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #1535152
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse