Let us say the SQL Server crashed and you are rebuilding the
databases including the master database what procedure to
you follow?
Answer Posted / guest
For restoring the master db we have to stop the SQL Server
first and then from command line we can type SQLSERVER ?m
which will basically bring it into the maintenance mode
after which we can restore the master db.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
what is database replicaion? : Sql server database administration
Can I use sql azure as a backup with log shipping or database mirroring?
What are the fixed server level roles? : sql server security
can a database be shrunk with users active? : Sql server administration
How is foreign key related to primary key?
What is spid in sql server profiler?
Does a sql server 2005 select statement require a from?
What is the difference between Triggers and Stored Procedure?
What is xdr?
How to name query output columns in ms sql server?
What are the basic features of a trigger in ms sql server?
What is the difference between a unique key and primary key?
Explain Normalization and DE normalization
How to set the current database in ms sql server?
Explain what is the function of sql server agent windows service?