Re: [ADSM-L] Tivoli SQL Server 2000 Restore Question*
2007-09-30 12:38:01
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
|
|
|