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
- 6885 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
How to remove duplicate rows from table except one?
Tell me what do you understand by a view? What does the with check option clause for a view do?
What is the use of @@spid?
How do you know if sql server is running on your local system?
Do you know clustered and non-clustered index?
Tell me what is normalization? Explain different forms of normalization?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
How to create nested stored procedure?
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
Explain why variables called the most powerful component of ssis?
How many types of triggers in sql server?
How to find the login name linked to a given user name?
What does indexation mean?
How do I setup a sql server database?
