[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 235
  • Last Modified:

Data Synch to a Remote DataCenter

I am trying to plan a DataCenter move and hopefully someone that has been through this before can offer some advice.  I have 2 SQL Servers, both are SQL 2000, 1 Enterprise (200 GB of Databases) and 1 Standard (400 GB Database).  The new Datacenter (about 700 mi away) has 2 SQL Servers as well, both Enterprise 2005.  The new DataCenter contains all new hardware; the hardware at the current Datacenter will remain there.

My question is the synchonization.  The Databases are highly transactional and they drive websites, so the web servers will be shut down for a period of time to do the final synch.  Obviously this needs to be as small a window as possible.   Due to the size of the Databases and the fact that the DB servers dont have firewire or usb2.0, copying to external drive and flying it up isnt an option.  That seems to leave either log shipping or replication.  I will have a dedicated pipe from one location to the other.  All the DBs are currently set to Simple for the recovery model, the drives the t-logs are on arent that big (32 GB) and I would be afraid if I changed the recovery to FULL the T-Logs could fill up drive while I was enjoying my weekend.  I dont want it to turn into a management nightmare.  Is Replication my best option?  And if so, which flavor, Transactional?

1 Solution
Replication is a lousy option, since not everything can be replicated.

Best solution is to take the downtime, detach, compress and robocopy all the files to the new place.

Next best option is to backup, restore in the new datacenter, then use Red Gate's SQL Data Compare to synch the data, one db at a time, then offline the original.

None of the options are pretty.

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now