Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lovecisco
Starting Member
3 Posts |
 Posted - 2005-03-02 : 06:36:28
|
| I currently have a production sql2k server running on old hardware.I upgrade with new hardware on anther server.what is the best way to migrate all databases to new server? Can't user detach and attach because production server can not be down.I can backup all databases to disk then restored on the new server before and run the restored on some of the most use datbase when taking production offline (may be 1 hour).anyone know where I can find all the documentation on how to accomplish this? I been search around but nothing show up yet?thanksLCThanks...Lovecisco |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2005-03-02 : 14:55:42
|
| http://support.microsoft.com/default.aspx?scid=kb;en-us;314546#2-Chadhttp://www.phxpoker.comPhoenix's largest online poker community |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-03-02 : 15:23:47
|
| We do this by doing a Backup and Restore, and then locking the original server (set DB to ReadOnly / SingleUser) doing a Differential Backup, restoring that onto the New Server, and then making the new server Live.We moved a live server recently running a multi-GB database in under 5 minutes using this process - we put a holding page on the web site saying "Upgrading hardward, please wait 5 minutes and Click Here" and users did not lose shopping carts etc.Kristen |
|
|
|
lovecisco
Starting Member
3 Posts |
Posted - 2005-03-03 : 06:21:53
|
| Thanks so much for respond. How are you backup the master, msdb, model to new server. I set the new server to single user mode to start up from command line. Do I restore these system datbase first before restored userdatabase?I am confusing the system databases. these system databases have to restored first?LCThanks...Lovecisco |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-03-03 : 08:33:21
|
| Why are you wanting to move the system databases?-------Moo. :) |
|
|
|
lovecisco
Starting Member
3 Posts |
Posted - 2005-03-03 : 09:37:32
|
| because I would like the new server is the same as the old one. and all the username and password that I don't have to recreated. I can't do DTS because the 2 server is not connect together...should I restord systems database to new store..??Thanks...Lovecisco |
|
|
|
|
|
|
Restore all databases to new sql2k server