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
How to create a view using data from another view?
What is the use of tempdb? What values does it hold?
What is sql server programming?
What happens if we shrink log file in sql server?
What are the High-Availability solutions in SQL Server and differentiate them briefly?
How to trouble shoot if unable to connect SQL Server
What is the purpose of sql profiler in sql server?
Can sql servers link to other servers?
What is raid and what are different types of raid levels?
sql database suspect We have a sql database that is showing as suspect. How can we recover?
on line cluster can we make if yes tell me the procedure
What are the parts of a function?
What are the differences between user defined functions and stored procedures?
What is an identity?
Explain about analysis services?