| Author |
SQL7 data recovery?
|
|
| Thunder God 2002-08-14, 4:23 pm |
| Hello all,
We are trying to do a disaster recovery test and we need it. We can't seem
to restore our master db through the cmd line or restore our data through
Enterprise mgr. Could anyone provide links to a doc(s) that thoroughly
discuss these steps? MS is not a big help here SFAIK.
Thank you all in advance.
| |
| BP Margolin 2002-08-14, 6:23 pm |
| Have you had the opportunity to check out the section "Restoring the master
Database from a Current Backup" in the SQL Server 7.0 Books Online?
-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.
"Thunder God" <idaman22@hotmail.com> wrote in message
news:uC1Sfu9QCHA.3360@tkmsftngp11...
> Hello all,
> We are trying to do a disaster recovery test and we need it. We can't seem
> to restore our master db through the cmd line or restore our data through
> Enterprise mgr. Could anyone provide links to a doc(s) that thoroughly
> discuss these steps? MS is not a big help here SFAIK.
> Thank you all in advance.
>
>
| |
|
|
| John Bell 2002-08-14, 10:23 pm |
| "Thunder God" <idaman22@hotmail.com> wrote in message news:<uC1Sfu9QCHA.3360@tkmsftngp11>...
> Hello all,
> We are trying to do a disaster recovery test and we need it. We can't seem
> to restore our master db through the cmd line or restore our data through
> Enterprise mgr. Could anyone provide links to a doc(s) that thoroughly
> discuss these steps? MS is not a big help here SFAIK.
> Thank you all in advance.
Check out the article in Books online
Restoring the master Database from a Current Backup
This tells you everything you need including how to set single user mode.
John
|
|
|
|