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 |
If suppose in a table ship(name,year),find ship name having first and last name(i.e having space in between) ex: SAINT LOUIS,JET LAKE.
What are the steps you will take to improve the performance of a poor performing query?
What are the mathematical functions supported by sql server 2005?
What is a collation in ms sql server?
What are subqueries in sql server? Explain its properties.
What is ms sql server index?
When do you think a developer should use sql server-based cursors?
What are different types of statements that are supported by sql?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What is ms sql server triggers?
How to retrieve error messages using odbc_errormsg()?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration