SQL 7 migration

[Ed Walters]

We have a SQL 7 server SP3 which we want to replace. The initial plan
is to create a new SQL 7 server and restore the database backups.

My first question is there any need to restore the master database
once all the other db's are copied.
We had planned to copy the databases and the msdb.
Do all the DTS jobs, users, security etc come over in the msdb.

Also is there any reason why we shouldn't upgrade to SQL 2000, are
there any compatiability issues with restoring the SQL 7 database
backups to the SQL 2000 server?

Ed

[Erland Sommarskog]

Ed Walters ([e-mail]) writes:

We have a SQL 7 server SP3 which we want to replace. The initial plan
is to create a new SQL 7 server and restore the database backups.

My first question is there any need to restore the master database
once all the other db's are copied.
We had planned to copy the databases and the msdb.
Do all the DTS jobs, users, security etc come over in the msdb.
Well, the master database have all the logins, and that is probably
information you want to keep.
Also is there any reason why we shouldn't upgrade to SQL 2000, are
there any compatiability issues with restoring the SQL 7 database
backups to the SQL 2000 server?

You can restore a backup from SQL7 on SQL2000, and likewise attach
a database created on SQL7 to an SQL2000 server.

Note however, that the reverse does *not* apply. You cannot restore
SQL2000 databases in any way on SQL7.
--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp