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

Wht is SQL Injection Attack ?

3 Answers  

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers  

How to throw custom exception in Stored Procedure?

0 Answers   MCN Solutions,

Explain why variables called the most powerful component of ssis?

0 Answers  

What do mean by xml datatype?

0 Answers  

two tables with table name ship(name,year) and battle (name,year),how to find the latest added year in the table ship

1 Answers  

How to write a query with a left outer join in ms sql server?

0 Answers  

What are some examples of schemas?

0 Answers  

Explain the new features of SQL server 2000?

1 Answers  

What are various aggregate functions that are available?

0 Answers  

What is cursor ? And what is difference between Trigger ?

3 Answers   HCL, Polaris,

WHICH IS THE BEST INSTITUTE IN HYD FOR "ORACLE"?

3 Answers  

For more SQL Server Interview Questions Click Here
Categories