Question related to recovery of SQL Server database..

In the event of SQL Server recovery... I have listed the following steps
(not detailed) as per reading SQL Server books online.
Step1. Install the SQL Server and related Service Packs
Step2. Restore the master database.
Step3. Restore the msdb (to restore the DTS packages and job schedules.)
Stpe4. Restore other system databases if it is required (optional).
Step5. Restore the user databases one after the other.. (Full backup,
differential backup and transactional backup..)
My question is..
After restoring the MASTER database, all the user databases information is
restored in the master database.
So.. Is it possible to restore the user database as the entries exist in
MASTER database? Is it possible to restore the user database just like any
other time that we restore the user database under different database name?
Since I cannot test the complete scenario I am looking for your opinion..
I am using SQL Server 2K.
Thank you all for your opinion.
Hanuman
Hi,
You can restore the user databases in any order. The order will not really
matter. You can also restore the user databases with new name this will add
new entries to sysdatabases, but the old entries in sysdatabases will remain
there. Only issue is incase if you have any logins defaulted to ur old
database
name needs to be changed using SP_defaultdb system stored procedure.
Thanks
Hari
SQL Server MVP
"Hanuman Mishra" <Mishra_Hanuman@.rediffmail.com> wrote in message
news:OpwFwX8ZFHA.4000@.TK2MSFTNGP10.phx.gbl...
>
> In the event of SQL Server recovery... I have listed the following steps
> (not detailed) as per reading SQL Server books online.
> Step1. Install the SQL Server and related Service Packs
> Step2. Restore the master database.
> Step3. Restore the msdb (to restore the DTS packages and job schedules.)
> Stpe4. Restore other system databases if it is required (optional).
> Step5. Restore the user databases one after the other.. (Full backup,
> differential backup and transactional backup..)
>
> My question is..
> After restoring the MASTER database, all the user databases information is
> restored in the master database.
> So.. Is it possible to restore the user database as the entries exist in
> MASTER database? Is it possible to restore the user database just like any
> other time that we restore the user database under different database
> name?
> Since I cannot test the complete scenario I am looking for your opinion..
>
> I am using SQL Server 2K.
> Thank you all for your opinion.
> Hanuman
>