|
Home > Archive > MS SQL Server > October 2005 > [novice Q] sequence in restoring system db
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
[novice Q] sequence in restoring system db
|
|
| rupart 2005-10-20, 8:23 pm |
| hi,
is there sequence in restoring system db?
shall i start with master, msdb followed by temp or the sequence doesnt
matter?
TIA
| |
| Rick Sawtell 2005-10-20, 8:23 pm |
|
"rupart" <rupart@discussions.microsoft.com> wrote in message
news:1A6DE952-27A0-4C19-B18E- AAF1C69F8A59@microso
ft.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
| |
| rupart 2005-10-20, 8:23 pm |
| got it...thanks rick
"Rick Sawtell" wrote:
>
> "rupart" <rupart@discussions.microsoft.com> wrote in message
> news:1A6DE952-27A0-4C19-B18E- AAF1C69F8A59@microso
ft.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
>
>
>
|
|
|
|
|