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

Mirror - 824 Corruption Expand / Collapse
Author
Message
Posted Thursday, December 12, 2013 6:13 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, August 15, 2014 2:48 AM
Points: 215, Visits: 858
Hi all

We've had a database mirroring session stop due to an error 824, mirror is in restoring state, I am trying to apply the latest t-log so I can bring it online and run a check db but I receive a could not redo log record error.

Now we have full backups so I can bring it back and resume mirroring, in fact only had to do this the other day but I would prefer to get the mirror online so I can at least see what the problem is! Any ideas?

Much appreciated as always.

D


'Only he who wanders finds new paths'
Post #1522272
Posted Thursday, December 12, 2013 6:58 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:14 PM
Points: 42,747, Visits: 35,835
If you're getting an error that a log record can't be redone, then that DB probably won't be coming online, except maybe in SUSPECT state. Try recovering the DB without restoring more logs (RESTORE DATABASE ... WITH RECOVERY)


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1522289
Posted Thursday, December 12, 2013 7:18 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, August 15, 2014 2:48 AM
Points: 215, Visits: 858
Gail you are by far my favourite superhero!

Yes I tried that initially and that didn't work and doing it since shows that a restore was interrupted and errors again.

I was trying to get online to DBCC Checkdb as this is now the second time that this has happened (to the mirror only) in a few days. I suspect there may be an issue with the IO subsystem on the mirror but need more details...which I cant get.

Thanks ever so much for the reply!


'Only he who wanders finds new paths'
Post #1522303
Posted Thursday, December 12, 2013 7:21 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:14 PM
Points: 42,747, Visits: 35,835
This will probably fail, but try ALTER DATABASE ... SET EMERGENCY. If it works you can run a CheckDB in that state (not with repair)

But any checksum failure is an indication of IO subsystem problems, the message in the error log will give you the file name.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1522306
Posted Thursday, December 12, 2013 7:29 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, August 15, 2014 2:48 AM
Points: 215, Visits: 858
Thanks Gail, sadly it gives a not permitted error. Looks like it is the restores then, although presumably as it error sits in IO its only a matter of time until it happens again. I'll have a word with the system admins!

Thanks again

D


'Only he who wanders finds new paths'
Post #1522310
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse