Let us say the SQL Server crashed and you are rebuilding the
databases including the master database what procedure to
you follow?
- 2 Answers
- 5897 Views
- I also Faced
- E-Mail Answers
Answer Posted / abc
first of all stop the sql services running and then we have
to bring the server in single user mode and by applying the
command sqlserver -m whose exe is located in the directory
C:\Program Files\Microsoft SQL Server\MSSQL\Binn can
rebuild the master database rebuildm (rebuild.exe)command
located at C:\Program Files\Microsoft SQL Server\80
\Tools\Binn directory at cmd prompt.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Can we write trigger for view?
How to identify current user in ssrs report?
What is 1nf 2nf and 3nf?
How to see the event list of an existing trigger using sys.trigger_events?
What is the difference between for xml raw and for xml auto?
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
What are exact numeric data types in ms sql server?
What is sql server transaction log file?
Difference between DELETE and TRUNCATE?
How to rebuild the master database?
What is a trigger? Why we need it?
When would you use a before or after trigger?
how many clustered indexes can be created on a table? : Sql server database administration
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?
What are statistics?
