
UNSOLVED
Restarting SQL 2005 on Mirror Veiw/A
Hi All
Two sites are Replicated by using mirrorveiw/A over a WAN Link .Primary Site has two Sql Servers All the (SQL)luns are replicated using Mirroveiw/A.
The coustomer wants to restart the SQL servers on the DR Site .I know the mirror veiw/A side but the concern is about the SQL side .The coustomer says mirroveiw replicates an open database and he cant load an open database to the DR Site server.The details of the environment is as given below.Please give me breif about the procedure in restarting the SQL i know about the mirrorveiw side just give me the hints about the sql please.
Storage:-AX4 5F
Server:-HP win 2003 64 bit ,SQL 2005
SAN Switch:-Brocade 300B
Router:Qlogic ISR
Responses (2)
Solutions (0)

driskollt1
131 Posts
227
1
Posted October 6th, 2010 08:00
Do you have a consistency group setup for all the LUNs for those databases? If not, you should probably do that - That might be why it doesn't work. That will make sure the data is in a crash-consistent state. Also, make sure you're replicating all LUNs with databases (tempdb and anything else as well) and logs on them (you might want to have 2 copies of the Logs, one in a consistency group and one that isn't in the consistency group that is updated as frequently as possible in case you need to roll forward).
If the DBA couldn't open a database in an "open state", then that would mean all server OS crashes would mean a restore. Esentially you're doing the same thing with MirrorView/A. You're bringing up a database in a crash-consistent state. SQL is capable of recovering in a crash-consistent state. That's why they have transaction logs.
If you want application consistent copies, you could write a script to periodically take a VSS snapshot of the LUNs (SQL 2005 may have the capability to do this automatically - Your DBA probably knows how to do this already.). Once the snapshot is created, you update your remote replica manually, then release the VSS snapshot. The script would just be a naviseccli command that the DBA could embed in his script when he creates the VSS snapshot.