Tim,
Yes... you are on the right track.
Take a look in the appendices of the Data Protection for SQL
User's Guide. It shows how to restore master and msdb.
Note: When you restore master, you will see an error at the end
of the restore procedure. That is normal.
Thanks,
Del
----------------------------------------------------
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 09/28/2007
02:22:18 PM:
Default *SQL Server 2000 Restore Question*
------------------------------------------------------------------------
I am restoring a SQL Server 2000 from scratch. The server has been built
and SQL has been installed and service packed to the appropriate level.
I am ready to restore the databases now to the fresh installation of SQL
Server. Is this the correct procedure when only the default databases
exist?
Start SQL in single user mode. Restore Master database.
Start SQL in multi user mode and restore msdb and model.
Restore the database files?
Thanks for any help or suggestions in advance!
TSM 5.3
Windows 2000 advance server
TDP 5.2.4
Tivoli Client 5.3.4
