January 18, 2012 at 5:58 pm
I have about 1TB of Databases that I need to move to a different Data Center in a different State.
The sizes of the uncompressed Databases vary from under 1GB to approximately 160GB.
It takes for ever to compress the backups but a bigger concern is if I simply copy the files.
What is the fastest and most reliable method to transfer the files?
Any help would be greatly appreciated.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 18, 2012 at 6:03 pm
Don't know about the US, but here in New Zealand I'd probably copy the file to tape and have it couriered the remote centre.
Cheers
Leo
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
January 18, 2012 at 6:06 pm
Something we have done is to backup the files to a USB drive and then courier the USB drive to the remote location.
For the differences between the two locations, do a diff backup and t-log backups. Copy those backups to the remote location.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 18, 2012 at 7:18 pm
Thank you!
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 18, 2012 at 8:48 pm
A lot depends on your network speed.
I recently moved a 400GB database (120 GB compressed Litespeed backup) by copying the full backup files over the network to the new location (took about 2 days) and mirroring the transaction log backups at the same time using ROBOCOPY. I made the full backup in multiple files, and used ROBOCOPY to copy them in parallel streams; that was a lot faster than copying a single large file.
I restored the full backup at the new location, and rolled the transaction logs forwarded leaving the DB in NORECOVERY until I was ready to go live on the new server. Then we stopped the app on the old server, made final trans log backups, and copied them to the new location. I applied the last tran log backups, recovered the DB, and then app was pointed at the new server. Total app downtime was less than one hour.
January 19, 2012 at 6:09 am
Thanks!
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply