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 |
|
infrontweb
Starting Member
13 Posts |
 Posted - 2003-10-13 : 13:35:47
|
| My apologies in advance for such a novice question.I currently have SQL 2000 running on a Win 2k server. This server is being replaced with a new Win 2003 server. I have 2 weeks to setup the new server an migrate all Database contents into the new server. The Database currently houses 12 small databases w/ Stored Procedures. I would like to do the following:1. Run both servers simultaneously. 2. Copy DB structure and SPs to new server.3. Copy current data to new server.4. Set DNS TTL to 5 minutes on old server.5. Make DNS change and point to new server IPs6. Sync the Databases until propogation is complete.7. Discontinue old server.8. No evidence of Down Time.Do I need to use SQL Replication Service?Does anyone know of an documented procedures that might help me?Thanks much,Eric |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-13 : 13:42:04
|
| Just use sp_detach_db and sp_attach_db when you want to move the databases to the new server. Both stored procedures are documented in SQL Server Books Online. There will be downtime when you do this, but it will be minimal. With any migration though, there will be downtime. With the DETACH/ATTACH method, the downtime will be as long as it takes to copy the MDF and LDF files to the new server, plus about 2 minutes.You could also use the BACKUP/RESTORE method, but it will have more downtime.You could also use replication as you mentioned, but that really isn't for migrations.Tara |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-13 : 13:43:24
|
| Have a look at this article for some more information:[url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;q224071[/url]Tara |
|
|
|
|
|
|
SQL Migration