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 master db itself has no backup. Now you have to
rebuild the db so what kind of action do you take?

Question Posted / guest


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 are the components of dbms?

0 Answers  

Can a function call a stored procedure in sql server?

0 Answers  

Find columns used in stored procedure?

0 Answers  

What is a trace frag? Where do we use it?

0 Answers  

Equi join and non equi join is possible with sql server?

0 Answers  

Can you please explain the difference between function and stored procedure?

0 Answers  

what is hash table

3 Answers   ILFS, Teledata,

What are various limitations of the views?

0 Answers  

How do I list the available tables in a database I'm querying?

4 Answers  

What is the definition for sql server 2000?

0 Answers  

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,

Why truncate is ddl command?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories