October 31, 2008 at 12:55 am
Dear All;
I am a MCDBA working with a repudiated share broking company. I would like to need some suggestion/help from your end. My Microsoft DBA Team work with zero downtime. My mostly Microsoft SQL server Databases on SAN (RAID-5) and for High availability of SQL Server we are using Windows Clustering (A/P). And my some SQL Servers on VMware Esx 3.1 Server. We are running approx 100 instance of SQL Servers and Some database size on SAN around 200GB.
My problem is below:
My company plan to move existing data center to new data center. Distance between existing and new data center is around 60km. and dedicated link between those data center is 100Mbps. The question is that “How to I plan to move my MS SQL Server Servers from existing Data Center to New Data Center?”
Kindly suggest me.
Ram
MSSQL DBA
October 31, 2008 at 3:23 am
If you were using SQL Server 2005 I'd recommend setting up mirroring between the two sites and then manually failover to the second site.
As you're not using SQL 2005 then I'd probably consider log shipping. Once log shipping is up and running you'd have to do one final (manual) log backup with norecovery of the primary database and then, once that's restored onto the secondary database, you'd recover it.
The only problem is you're going to have to allow for about 5 minutes of downtime. You could possibly do it with less downtime but allow for at least 5 minutes.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply