July 26, 2012 at 11:34 am
Hi Guys,
I am working on a project to migrate SQL Server 2005 databases from one Datacenter to another. Each SQL Server instance has more than 500 databases with total size of 2TB. I would like to get yours suggestions for the best approach to migrate the databases with minimum down time.
Thanks in advance.
July 26, 2012 at 11:37 am
script, script, script.
Get a process inline that
- moves a full backup from instance A -> B
- restore this on instance B
- if this takes a long time, make a diff on A
- move diff from A-> B
- restore diff on B
- make log backups on A
- move log backups A-> B
- when the time for the two previous steps is low, offline the db on A, bring it up on B, repoint users to B.
If this is fairly well scripted, you can move multiple databases at once. Watch the sizes of the backups and move ones that don't saturate your pipe at the same time.
If you need the same names on the hosts, how much downtime can you take? How far are the data centers apart? I've seen people take a day and drive servers from A-> B
July 26, 2012 at 12:05 pm
Thanks! Steve
Datacenters are very far apart. We are planning to put the database on tape and send it to second datacenter and copy the transaction log files over the network and then synch the databases and create log shipping using scripts.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply