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

Why use view instead of a table?

Write a program using SQL queries to find a unique entry in a table.

What is a periodical index?

What is the Main Difference between ACCESS and SQL SERVER?

How to connect to a sql server using odbc_connect()?

Why we need sql server?

What is the use of @@spid?

Explain primary key, foreign key and unique key?

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

Explain differentiate between a having clause and a where clause?

Can the query output be sorted by multiple columns in ms sql server?

I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000

For more SQL Server Interview Questions Click Here