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 |
|
STL8BRU
Starting Member
1 Post |
 Posted - 2004-09-21 : 05:27:26
|
Hi,I had to migrate our sql server from msql7 to sql2000Is there somebody in your team who has experience with this subject??My questions are:1) for the databases with the datas can I use the option attach database without other process?2) how migrate the MSDB database?Thank you for you help  |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-09-21 : 07:37:08
|
| You really should migrate this way:1. Script out the users using sp_help_revlogin (you can find it on the site).2. Script out the jobs.3. Script out the operators.4. Save the DTS packages out as files.5. Backup ALL the databases.6. Restore the user databases.7. Use the script from sp_help_revlogin to add the users back in.8. Add the operators back in.9. Add the jobs and DTS packages back in.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
migration MSDB to SQL2000