Let us say master db itself has no backup. Now you have to rebuild the db so wh

Let us say master db itself has no backup. Now you have to
rebuild the db so what kind of action do you take?

Question Posted / guest

Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do..

first you rebuild the master db by using REBUIDM.exe. after
u take single user mode Sqlservr.exe -c -m.

Is This Answer Correct ?

6 Yes

0 No

More SQL Server Interview Questions

What is sorting and what is the difference between sorting and clustered indexes?

What is the difference between temp table and table variable?

Explain indexing and what are the advantages of it?

What is blocking in SQL Server? If this situation occurs how to troubleshoot this issue

can primery key be a non clustered index?

What is an index in sql?

What is the security model used in sql server 2005?

What are commit and rollback in sql?

What is a table called, if it does not have neither Cluster nor Non-cluster Index?

What is a system database and what is a user database?

What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

If any stored procedure is encrypted, then can we see its definition in activity monitor?

For more SQL Server Interview Questions Click Here