| Author |
Recover the MSSQL Server 2000 from DLT Tape
|
|
|
| Dear all,
I would like to ask if I can recover those databases from tape if I just
backup all the folders under the "C:\Program Files" ? I have export those
databases to files...
As my server's HDD is fail and I only get the DLT Tape back.
Please give me some advises!
Thanks all!
| |
|
| if you have valid backup of c:\program files\ microsoft sql server\....\data
folder and your data files are in this folder you can attach the mdf and ldf
files to another servers.
Look for sp_attach_db in BOL
not sure what you meant with "I have export those databases to files..."
"Kevin" <Kevin@discussions.microsoft.com> wrote in message
news:D8A6D646-6778-4DA1-AA50- 7D50383E1B09@microso
ft.com...
> Dear all,
>
> I would like to ask if I can recover those databases from tape if I just
> backup all the folders under the "C:\Program Files" ? I have export those
> databases to files...
>
> As my server's HDD is fail and I only get the DLT Tape back.
>
> Please give me some advises!
>
> Thanks all!
| |
|
| Thx for your reply!
actually, it's my typing mistake...
it should be "i haven't exported those database as a file"
"ME" wrote:
> if you have valid backup of c:\program files\ microsoft sql server\....\data
> folder and your data files are in this folder you can attach the mdf and ldf
> files to another servers.
>
> Look for sp_attach_db in BOL
>
> not sure what you meant with "I have export those databases to files..."
>
>
>
> "Kevin" <Kevin@discussions.microsoft.com> wrote in message
> news:D8A6D646-6778-4DA1-AA50- 7D50383E1B09@microso
ft.com...
>
>
>
| |
|
| so you were able to attach the mdf and ldf files?
"Kevin" <Kevin@discussions.microsoft.com> wrote in message
news:FF8B6AC6-7F80-4D83-B14C- 2A21235E56D8@microso
ft.com...[color=darkred]
> Thx for your reply!
> actually, it's my typing mistake...
> it should be "i haven't exported those database as a file"
>
> "ME" wrote:
>
|
|
|
|