DATA CENTER Relocation

Question

Post reply

DATA CENTER Relocation

S Q L DBA

Newbie

Points: 3
More actions
July 2, 2009 at 11:50 am

#155904

Just got the word that Our Data Center Hosting Vendor will be changed in the end of the year.
Bunch of the SQL Servers would need to be relocated to another hosting vendor.
Among the dozens of DBs, the Biggest DB is around 400GB.
Most of the Servers are running with SQL Server 2005 sp3, one server with SQL 2000.
I know they will set up all the servers completely new. There will be SAN.
And I will be responsible to migrate all the Data to the new hosts and work with the APP people to get things run in the new environment.
Wondering there is anyone who has gone through this kind of process?
What is the best way to get the data to the new env.?
any lessons/advice/suggestions will be greatly appreciated!
TIA.

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

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

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 1

Can you afford a down time?

1- Pre create all databases in new location.

2- Take a final full backup and put it on an external disk drive

3- Ship the external disk drive overnight

4- Restore in new location

5- Be happy ever after

PS: Don't forget to script jobs, credentials, etc in the old location and apply those scripts on the new location 😉

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Richard M. SSCertifiable Points: 7401 More actions · Answer 2

You might also want to check here[/url]

_______________________________________________________________________
For better assistance in answering your questions, click here[/url]

s007reddy SSC Veteran Points: 255 More actions · Answer 3

offcourse Pablo (Paul) Berzukov covered most of the points.

In addition to that, now you have huge SAN in hand. So you can scatter your data files, log files of user database(s) and TEMPDB files into different disks (Check your server configurations like how many Processors (CPU) and memory and also verify your what level of RAID)

Regards

SRI