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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-24 : 18:02:32
|
| Jim writes "We have a new SQL server 2000 machine, and I am transferring theDB's from our old 7.0 server to the new server via detach and attach. I moved all the user DB's and they updated to 2000 as I attached them. I want to also move the msdb over from 7.0 so as not to lose our jobs, but mainly not to lose our many DTS packages. I received a message that I could not detach the msdbdatabase, so I shut down both servers and copied the msdbmdf and msdbldf files over, restarted the new 2000 server, and the packages and jobs show up. However, I cannot start the server agent. The message says it is expecting a different instance of the agent. Do I need to do something additional, or do I need to put the original msdb files back from the 2000 installation and re-create all the packages by hand?Thanks!!!" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-03-24 : 22:56:14
|
| I would put the original files back.You can transfer your jobs via DTS. You can also save your DTS packages by opening them on the old server, and saving them to the new server. There is no need to recreate them.-Chad |
 |
|
|
|
|
|
msdb--can it move from 7.0 to 2000