hi,
is there sequence in restoring system db?
shall i start with master, msdb followed by temp or the sequence doesnt
matter?
TIA
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:1A6DE952-27A0-4C19-B18E-AAF1C69F8A59@.microsoft.com...
> hi,
> is there sequence in restoring system db?
> shall i start with master, msdb followed by temp or the sequence doesnt
> matter?
> TIA
You will need to restore the master db first. You should check the BOL on
restoring the master database.
Do a search for "Restoring the master Database from a Current Backup"
After that, the other databases order doesn't matter a whole lot.
You do not restore tempdb, it is recreated every time the SQL Server is
restarted.
Rick Sawtell
MCT, MCSD, MCDBA
|||got it...thanks rick
"Rick Sawtell" wrote:
> "rupart" <rupart@.discussions.microsoft.com> wrote in message
> news:1A6DE952-27A0-4C19-B18E-AAF1C69F8A59@.microsoft.com...
> You will need to restore the master db first. You should check the BOL on
> restoring the master database.
> Do a search for "Restoring the master Database from a Current Backup"
> After that, the other databases order doesn't matter a whole lot.
> You do not restore tempdb, it is recreated every time the SQL Server is
> restarted.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment