Best way to migrate SQL Server

Associate
Joined
19 Jul 2006
Posts
258
Location
Gibraltar
Well, as per title.
Need to move current SQL server over to a nice new server xD

the current server setup is like :

C Drive
system files, program files etc
D Drive
Contains all SQL server information and other database log files etc.

What is the best way to clone the server including its partition information and database files, over to a new server :S

Any advice appreciated

EDIT - total size for all the files on the D drive is about 80GB
 
Last edited:
hmm yea i spose...problem is it needs to be done out of office hours and id like to keep it as quick as possible.
Apart from that there are databases from both SQL server 2000 and SQL server 2005.

Im really not that knowledgeable with SQL I just do general maintenance of the databases adding users etc. So the above seems a little daunting :S

what u think?

EDIT - theres also a couple of proggies not installed by myself like Mailmeter, where they had to connect remotely to install, that I'd rather not have to reinstall :/

PS - thanks for help :)
 
Last edited:
hmm i spose i should have mentioned this then.
The old server is a DL360G4p the new server is a DL360 G5...reckon that would still give problems?
 
Back
Top Bottom