Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Let us say the SQL Server crashed and you are rebuilding the
databases including the master database what procedure to
you follow?

Question Posted / guest

Answers were Sorted based on User's Feedback



Let us say the SQL Server crashed and you are rebuilding the databases including the master databas..

Answer / abc

first of all stop the sql services running and then we have
to bring the server in single user mode and by applying the
command sqlserver -m whose exe is located in the directory
C:\Program Files\Microsoft SQL Server\MSSQL\Binn can
rebuild the master database rebuildm (rebuild.exe)command
located at C:\Program Files\Microsoft SQL Server\80
\Tools\Binn directory at cmd prompt.

Is This Answer Correct ?    5 Yes 0 No

Let us say the SQL Server crashed and you are rebuilding the databases including the master databas..

Answer / guest

For restoring the master db we have to stop the SQL Server
first and then from command line we can type SQLSERVER ?m
which will basically bring it into the maintenance mode
after which we can restore the master db.

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More SQL Server Interview Questions

Diffrent types of function

1 Answers   Wipro,

what is the diffrence between Snap Shot and Transaction Replication

2 Answers   CSC,

Why are views required in the sql server or in any other database?

0 Answers  

What is difference between join and natural join?

0 Answers  

How to find the list of fixed hard drive and free space on server?

0 Answers  

What is factless fact table? : sql server analysis services, ssas

0 Answers  

why would you call update statistics? : Sql server database administration

0 Answers  

Describe in brief authentication modes in sql server.

0 Answers  

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

0 Answers  

What is auditing in sql server?

0 Answers  

how many non clustered index in sql server 2008,2010,2012

2 Answers   Accenture,

What are the main control-of-flow T-SQL constructs?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories