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
- 6918 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
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
Give me a SQL Query to find out the second largest company?
Should you normalize audio?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
What is delete query?
Why the trigger fires multiple times in single login?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
What is data source in connection string?
What do you mean by recursive stored procedure?
Which sql server table is used to hold the stored procedure script?
What are the steps to process a single select statement?
What options are available to audit login activity? : sql server security
Indexes are updated automatically is the full-text index also updated automatically?
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
What are trace flags?
