October 7, 2009 at 9:22 am
We had a consultant onsite who setup the production DB to mirror to a DR site SQL instance. Asynchronous mirroring set to mirror every minute. It has been synching to these DR site so far. I am picking up these tasks from the guy but ofcourse no knowledge transfer. So, i would like to perform certain tasks and have questions about them;
1.Checking mirrors integrity. After I get a DB snapshot of the mirror; how can I check it with the live copy to ensure integrity?
2.Using SQL management studio; under the DB properties >> Mirroring screen, i see a button called Failover. Is this the only way to failover to the mirror? Are there other better alternatives to failover?
•Does a failover involve creation of the snapshot on the DR instance?
•After the failover, how does the mirror reconcile transactions back with the live instance?
Any insight is much appreciated ...
October 7, 2009 at 9:30 am
I'd recommend you read about database mirroring in BOL (Books Online, the SQL Server Help System). That should provide you was some basic knowledge regarding DB Mirroring. After reading BOL, you should be able to come back here with more specific questions to help clarify that which will still be muddy.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply