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

What is the difference between insensitive and scroll cursor?

0 Answers  


How to use subqueries in the from clause in ms sql server?

0 Answers  


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

0 Answers  


What are four major operators that can be used to combine conditions on a where clause?

0 Answers  


Differentiate between ms sql server reporting services vs crystal reports?

0 Answers  






How do I connect to sql server database?

0 Answers  


Explain the storage models of OLAP?

1 Answers  


How to create a simple user defined function in ms sql server?

0 Answers  


What is star, snowflake and star flake schema? : sql server analysis services, ssas

0 Answers  


What is the difference between count and distinct count?

0 Answers  


What does the automatic recovery do?

0 Answers  


How can change procedure in sql server?

0 Answers  


Categories