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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Do you have any idea about the tcl commands?

711


plss anybody specify tha constrian management system in dbms

1797


Explain “not null constraint” in sql server?

720


What is ms sql server service broker?

676


What are the different types of backups avaialabe in sql server 2005?

771






What is row-level compre?

713


What is Replication?

808


How will you find out if there are expensive SQL statements running or not?

762


What is sql server english query?

743


How secure is sql server database?

685


List out different types of normalizations in sql server and explain each of them?

713


Define union, union all, minus, intersect?

741


Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

715


Can truncate be rolled back?

699


Do you know what is difference between stored procedure and user defined function?

798