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
- 7002 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
What is #table in sql server?
explain how to create a new schema in a database? : Sql server database administration
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
Explain the truncate command? : SQL Server Architecture
Why and when do stored procedure recompile?
What are sql azure firewall rules?
How is sql server used?
How to drop existing views from a database in ms sql server?
What are window functions in sql server?
Explain throw statement in sql server 2008?
What is the use of @@spid?
how you can configure a running aggregate in SSRS?
Explain Capacity planning to create a database? and how to monitor it?
What is cdc in sql server?
How to Sync Two SQL Azure Databases?
