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?