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

Explain ranking functions?

0 Answers  

What is the use of DBCC commands?

4 Answers   NA,

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

0 Answers   IBM,

What is CTE in SQL

0 Answers   Infosys,

Diff. b/w Full Outer Join And Cross Join?

3 Answers  




How to install sql server 2005 express edition?

0 Answers  

How do I manually uninstall an instance of sql server 2016?

0 Answers  

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

0 Answers   HP,

Why should we go for stored procedures? Why not direct queries?

0 Answers  

wat wil hapn if we give the both read and deny read permission to user?

0 Answers   IBM,

What is master database? : SQL Server Architecture

0 Answers  

What are the components of sql server service broker?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories