How to get the data there ....

Question

How to get the data there ....

Chris Kitchen

Hall of Fame

Points: 3090
More actions
September 4, 2007 at 4:17 am

#118545

Hi,
I need to get data from 100 live SQL Server 2005 production databases into our DR data centre which is over 100 miles away.
The reason for copying the data is, I am implementing SQL Mirroring for 95 of the database, and SQL Log Shipping for the other 5.
I have a 16MB pipe between the two data centres and the size of the 95 databases that will be mirrored totals 300GB and the size of the other 5 databases that I will be using log shipping for totals 15GB.

What is the best way to get the data into the DR data centre? Due to the physical distance backing everything up onto tape any driving to the DR data centre would take too long.

For the Log Shipping databases should I use the "Backup and Restore" option as part of the Log Shipping Setup Wizard?

For the databases that will be mirrored I am assuming that I will need to take a full database backup and a log backup, which will mean pausing the scheduled job that takes the log backups to ensure that the log I restore into the DR data centre is the last log backup taken from the primary database to ensure the primary and the mirror are in sync - is this correct?

Any thoughts would be greatly appreciated.

Thanks in advance.
www.sqlAssociates.co.uk

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Krishna Mohan Kasi Mr or Mrs. 500 Points: 593 More actions · Answer 1

What i can think of is Replication. you can setup replication and once everything is in sync you can disable replication.

I know its a hard way.

Also you can consider the option to check the backup and restore options considering the size of your databases it would take a lot of time.

all the best.

bnordberg SSCertifiable Points: 5480 More actions · Answer 2

I think compression is your best bet. Can you zip or use a product like light speed to compress a backup, then move those across your network and restore on the other side?

Chris Kitchen Hall of Fame Points: 3090 More actions · Answer 3

Hi guys,

Thanks for replying to my post. I will be using a compression tool, and will be moving the database backups in smaller chunks.

Could you please help me with the final question:

"For the databases that will be mirrored I am assuming that I will need to take a full database backup and a log backup, which will mean pausing the scheduled job that takes the log backups to ensure that the log I restore into the DR data centre is the last log backup taken from the primary database to ensure the primary and the mirror are in sync - is this correct?"

Thanks in advance.

www.sqlAssociates.co.uk