Master, Model, MSDB move question 1

[mikehiland]

We have a SQL2000 server which is about to be replaced by a SQL2005 server. I have done the following:

Generated an SQL script on SQL2000 and recreated all jobs on SQL2005.

Used Save As on each DTS package to save them to the SQL2005 server.

Restored each database from latest SQL2000 backup files to SQL2005 server.

In testing our applications, everything seems to be fine.

Do I also need to copy the Master, Model, and MSDB databases to the SQL2005 server? If so, what is the best method to move or copy them?

Thanks!

 

[ptheriault]

No don't copy them. They are system databases. You may want to script your jobs from the msdb database but don't copy the database.

- Paul
- If at first you don't succeed, find out if the loser gets anything.