November 1, 2006 at 9:15 am
Say if you have a db that returns some sort of error when you run dbcc checkdb.. if you are log shipping that db, would you expect the same dbcc errors on the shipped server?
November 1, 2006 at 2:38 pm
I would say NO. For example, DBCC CHECKDB may detect errors due to hard disk failure. We cannot expect these errors occur at the same time and at the same spot.
Any people would like to input?
November 2, 2006 at 5:45 am
It all depends upon the actual error, I haven't had too many but I recollect that a backup which contains an error will not usually restore so you get an early warning so to speak. I've always used home grown log shipping so can't confirm this will be the same with ms log shipping.
Some errors could transfer I guess - sort of depends - as I say you tend not to get too many such problems and it's difficult to reproduce in a test environment.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply