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
- 6761 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 etl - extraction, transformation, and loading?
Can We Use Data-grids For Our Report In Ssrs?
What is row-level compre?
What is the difference between NOROW and LOCKROW?
What is a view in sql?
What is a synonym for manipulation?
What is the temp table?
How to retrieve error messages using odbc_errormsg()?
What are data resources?
How to apply filtering criteria at group level with the having clause in ms sql server?
What are the difference between primary keys and foreign keys?
What is self join in sql server joins?
When to use Inner join & when to use subquery?
What is inner join in sql server joins?
What are the database objects? : SQL Server Architecture
