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 dbcc updateusage?
List the data types available in mssql?
How can we check the sql server version?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
What are different types of join?
What is postgresql server?
How to enter binary string literals in ms sql server?
What is xml datatype?
What are basics of policy management?
What are the lambda triggers?
What are the properties of primary key?
You want to implement the many-to-many relationship while designing tables. How would you do it?
What will happen if a column containing char type data is changed to the nchar data type?
What are clustered and non-clustered index?
How do I find information about the install locations for the various instances running on a computer?