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

can you any body tell me simple recovery,full recovery,bulk
logged recovery where can use?

Question Posted / prasadhari_m@yahoo.com


can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?..

Answer / laxman

full - every transaction will be recorded in t-log
bulklog - bulk transactions like select into will not be
recorded in t-log
simple - no logs will be recoreded.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is repeatable read?

0 Answers  

What are the different sql server versions?

0 Answers  

how to delete duplicate rows in sql server2005

7 Answers   Cisco, CTS, HCL, IBM,

What are the advantages of the mirroring?

0 Answers  

Which table keeps the locking information?

0 Answers  

What is Primary key and foreign key? Give an example

4 Answers   TCS,

Can foreign key be duplicate?

0 Answers  

Can you tell me the difference between DELETE & TRUNCATE commands?

15 Answers  

How sql server executes a statement with nested subqueries?

0 Answers  

What is 5nf in normalization form?

0 Answers  

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

0 Answers   HCL,

Why use triggers?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories