ESAT ERKEC (11/10/2012)
Why you don t use database mirroring
In database mirroring, if the primary database is corrupted for any reason other than hardware failure, then the mirror database will be corrupted in the same way.
No it won't.
Unless by 'corruption' you mean user deleting the incorrect data, in which case your backup/restore will have the same problem.
In fact, backup/restore will copy across page corruption while mirroring won't.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)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