by Step1 Run REBUILDM
You'll need to run rebuildm to rebuild the master database - and all of the
other system databases. IF you're running this on ss2k then you need to make
sure you point the data files path to a location where the files are not set
to read only. If I copy them from a network location I'll usually point a
second command prompt at the \program files\microsoft sql server\mssql\data
directory and then run "attrib *.* -r" over and over again while the files
are being copied. This will make sure that as they are copied the r/o bit
will be turned off. If it's not turned off then the "updating server
configuration" dialog will just stay there forever (well 13 hours is the
longest I've heard someone waiting :). Anyway, rebuildm should only take a
few minutes after the copy. If you have any doubts copy the x86\data
directory to a local drive and point rebuildm at that.
Step2 Start SQL Server in single user mode
go to the instance binn directory
\program files\microsoft sql server\mssql\binn and run
sqlservr -m
Restore master from the most recent backup. Once restored it will stop the
server.
Restart the server and then restore the msdb, and optionally the model, pubs
and northwind databases.
At that point you should be back up and running.
Good luck,
Kimberly
Kimberly Tripp-Simonnet
********************
Please do not send mail to me directly - reply on the newsgroup.
Please include legible and tested snipits (and ddl) of code. This makes it
easier to test and answer. Thanks!
Quote:> if master database crashes, how should I restore?
> can you explain me in steps
> thanks in advance