Let us say the SQL Server crashed and you are rebuilding the
databases including the master database what procedure to
you follow?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
What are logical database components? : SQL Server Architecture
How to convert a table data in XML format in sql server?
What is Left Outer Join?
how many type of subquery?
what is a deadlock? : Sql server database administration
What are the properties of the relational tables?
What is the difference between a Application Server and a Database
how to find number of columns in a table in sql server 2000 and 2005 also
What is a Join in SQL Server?
what is a transaction? : Sql server database administration
What is database black box testing?
What stored by the master? : sql server database administration
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)