"Moti" <Mo*****@gmail.com> wrote in message
news:67**************************@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