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 |
|
keithc
Starting Member
35 Posts |
 Posted - 2004-11-08 : 17:36:33
|
| Hi need some help here. Scenario:Existing Sql 2000 box is going to be formattedSame box is being made a 2003 server DC (First DC in new domain)What needs to be done:I need to get the old sql onto the new boxWhat i was planning is Detaching all db's copying to network share then backing them upThen formatting the box putting 2003 server onInstalling SQl 2000 pac it to sp3 then copy db's that were detached from the network share to the newly installed sql box and then attaching and reapplying security. I dont even know if the above is correct way of doing this and I'm also confused how to get the logins over as well and should I keep the sql box the same name as the old etc. |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2004-11-08 : 17:39:30
|
| That will work. You will have orphaned users in all of your DBs though. You will need to recreate all of the logins and map them to the existing Database Users. Other than that, your method should work. I would suggest also taking backups of everything as well.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
keithc
Starting Member
35 Posts |
Posted - 2004-11-08 : 21:26:36
|
| Doing a test run and so far detach is going fie except I can't detach Master. I set the T3608 flag for startup which let me detach model/msdb/tempdb but still not sure what to do with master. Should I just do a restore to new sql install from backup of master on old install? Instead of doing detach should I maybe just do a backup of all db's then copy out those backups to a network share then restore to new sql install? Actually if I stop the sql service isnt that the same as detachment as well? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-09 : 12:45:39
|
| Yes stopping the service is the same as detaching.Tara |
|
|
|
CanadaDBA
583 Posts |
|
|
|
|
|
Moving Sql Server