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



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

Do you know spatial data types - geometry and geography in sql server 2008?

0 Answers  


What is an execution plan? When would you use it? How would you view the execution plan?

1 Answers  


What are the basic functions for master, msdb, model, tempdb and resource databases?

0 Answers  


What is row_number () and partition by in sql server?

0 Answers  


Can you explain different types of locks in sql server?

0 Answers  






How do you know which index a table is using?

4 Answers  


what is differece between union and union all

6 Answers  


Define a cross join?

0 Answers  


What is the basic functions for master, msdb, tempdb databases?

2 Answers   CSC,


How to enable/disable indexes?

0 Answers  


What is stored procedures?

0 Answers  


What happens if null values are involved in datetime operations?

0 Answers  


Categories