1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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..

Answer / hari

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

Post New Answer

More SQL Server Interview Questions

What are the different types of collation sensitivity?

0 Answers  

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

0 Answers  

What is plan freezing?

0 Answers  

I have Two table First have UserName and second is address, in address table more than value relegated to UserName table, i want to fetch 2nd address if exist other wise 1st address access

4 Answers  

What are security principals used in sql server 2005?

0 Answers  




one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.

1 Answers   Cognizant,

Does a sql server 2005 select statement require a from?

0 Answers  

How to create a view with data from multiple tables?

0 Answers  

Do you know what is bit data type and whats the information that can be stored inside a bit column?

0 Answers  

List all types of constraints in sql server?

0 Answers  

How to replace null values in expressions using isnull()?

0 Answers  

how to get the salary in descending order with out using the keyword desc in sql

5 Answers   Ramco,

For more SQL Server Interview Questions Click Here
Categories