restoring system db's on new instance

Hi There

We have a database server that must be completely re-setup, the hard drives will be replaced and the OS and Sql Server 2000 EE edition re-installed from scratch, a fresh new instance.

However the client has requested that we restore the master and msdb databases of the old instance over the new one once it is installed.

Now is this ok to do ? Can i simply restore a backup of master and msdb ont he new instance and what is the correct procedure to do this ?

I am not to worried about the user DB's i will simply dettach and re-attach. But must this be done before or after restoring the old master if i can do that ?

Thanx

To restore Master db you should build your box with exactly same OS and SQL configuration as from which you have taken the backup. ie. OS and sql server has to be same version /edition/sp /patches applied

Refer this : http://support.microsoft.com/kb/264474

Madhu

|||

These resources may help:

http://msdn2.microsoft.com/en-us/library/ms345408(en-US,SQL.90).aspx Moving system dbs 2005
http://www.databasejournal.com/features/mssql/article.php/3379901 Moving system DB's 2000
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases to a New Location with Detach/Attach
http://www.support.microsoft.com/?id=221465 Using WITH MOVE in a Restore
http://www.sqlservercentral.com/columnists/cBunch/movingyouruserswiththeirdatabases.asp Moving Users
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to users