December 20, 2009 at 8:34 pm
Hi,
I am a newbie to SQL so need a bit of help! I currently have a SQL server 2005 cluster in place with 2 nodes. Every year my company duplicates our server infrastructure in a remote location as a disaster recovery process. SO i have to setup a complete copy of the sql server cluster we have in our environment. The system admins will create a duplicate of the OS and the cluster and i will then have to the database part. Can someone body help me with the steps i need to do to create a mimic of my current environment. Appreaciate any help !
December 21, 2009 at 2:41 am
Install the DR instance with the same version and collation of the Prod.
Then, copy your DBs, Logins, SPs...either throught wizard or backup/restore
December 21, 2009 at 6:16 am
You can also perform detach / attach for your user database.
But yes you need to transfer Jobs, users etc.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 21, 2009 at 7:52 am
Thanks for the quick replies guys...
I basically have to create step by step document for the offshore to follow:
1. First sysadmin will take care of the MSCS and OS part.
2. Then i will have to install the SQL Cluster (which i kinda know how to do)
3. Now after the sql is installed i know how to restore the user db's.
But i am bit confused about the system db's. Do i restore the master,msdb and model from the backup?
December 21, 2009 at 4:43 pm
Yes, you need to restore system db's too as those will bring logins, linked servers, jobs, operators etc. on your DR server.
MJ
December 22, 2009 at 2:08 am
If you chose to restore the system DBs, be careful about the servername (Hostname) registered on the SQL Server.
I rather recreate the objects (just generate the scripts and run them on the DR env.)
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply