Interested to Buy Any Domain ? << Click Here >> for more details...
Let us say the SQL Server crashed and you are rebuilding the
databases including the master database what procedure to
you follow?
- 2 Answers
- 7006 Views
- I also Faced
- E-Mail Answers
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 difference between aggregate and analytic function?
What is report server project?
What is transactional replication?
What is clustered primary key?
Can select statements be used on views in ms sql server?
Define outer join in sql server joins?
How to find which stored procedure is currently running in sql server?
Explain identity in sql server?
How would you choose between a clustered and a non-clustered index?
Why de-normalization required?
How to create indexed view?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
What is the impact on other user sessions when creating indexes?
What is the difference between a function and a stored procedure?
what are acid properties? : Sql server database administration
