Recover Master database fron only MDF file

I have SQL server 2000 which recently crashed. I try to recover it and
found out that the Master database is corrupt. I never backup my
server using inline sql backup nor any third party backup program that
aware to SQL server. But I have full system backup of volume c on tape
(using NTBackup), which includes old version of Master database. My
questions are:

1. How can I recover this file into SQL server?
2. If so, it is not risky to recover Master database from two weeks
ago?

Thanks in advance!"Moti" <Moti.Ba@.gmail.com> wrote in message
news:67f10867.0410101311.1317a99e@.posting.google.c om...
>I have SQL server 2000 which recently crashed. I try to recover it and
> found out that the Master database is corrupt. I never backup my
> server using inline sql backup nor any third party backup program that
> aware to SQL server. But I have full system backup of volume c on tape
> (using NTBackup), which includes old version of Master database. My
> questions are:
> 1. How can I recover this file into SQL server?
> 2. If so, it is not risky to recover Master database from two weeks
> ago?
> Thanks in advance!

It's not clear what you mean by "corrupt" - can you actually start MSSQL?
Have you used DBCC CHECKDB? Assuming that MSSQL is running (or that you have
another installation/instance you can use), you could try this:

1. Use sp_attach_single_file_db to attach the database with a different
name, eg. master2
2. Backup the master2 database
3. Restore master2 backup over master - see "Restoring the master Database
from a Current Backup" in Books Online
4. Use sp_attach_db to attach any databases which you created in the last
two weeks

If it works (which is not at all guaranteed), then you would lose anything
that changed in master over the past 2 weeks, such as logins, linked server
definitions, database locations etc.

If it doesn't work, you can try rebuilding the master database, then
reattach your user databases - see "Rebuilding the master Database" in Books
Online.

If you want a quick way to get started with a backup/restore plan, you
could create a maintenance plan to backup all your databases for you. But
you should still read up on backup/restore in Books Online, because your
requirements might be more complicated than a simple maintenance plan.

Simon

Recover Analysis Server from crash recovery

I've server where I recover...\Data and ...\Bin\*.mdb. from backup tape. My
server came on-line with no error, i've not detect lost data, but, I don't
know if AS is now all fonctional or i need some configurations for finish
recover. The books on-line from Microsoft site have not information about
crash recovery.
Please can you tell me if i need some other restore files or other
configurations on AS ?
Thanks.
Sylvain H.
You don't need anything else...
Bye
Francesco Anti
"SHuet" <SHuet@.discussions.microsoft.com> ha scritto nel messaggio
news:CEAE3231-6CCA-421B-AF82-D255ADFB3EA5@.microsoft.com...
> I've server where I recover...\Data and ...\Bin\*.mdb. from backup tape.
> My
> server came on-line with no error, i've not detect lost data, but, I don't
> know if AS is now all fonctional or i need some configurations for finish
> recover. The books on-line from Microsoft site have not information about
> crash recovery.
> Please can you tell me if i need some other restore files or other
> configurations on AS ?
> Thanks.
> Sylvain H.
>