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 |
How can sql server instances be hidden?
in my server i have 3 instances,one of them got failed, and this cause we r not able to connect to server, how to know which instance was dameged?
What are ddl triggers and types of ddl trigger?
Does any body please help me what question's have asked for SSRS in the interview?
Explain about Joins?
What is db stored procedure?
How to get number of days in a given year?
What are trace flags and mention a few common trace flags used with sql server?
How to implement service broker?
what is memory-optimized nonclustered indexes
Tell me what is use of except clause? How it differs from not in clause?
What are window functions in sql server?
Oracle (3253)
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)