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

Tell me what is normalization? Explain different forms of normalization?

0 Answers  

Explain features of analysis services?

0 Answers  

What is 4nf in normalization form?

0 Answers  

How you can add messages to the nt event log from within a stored procedure?

0 Answers  

What is the security principal at the server level that represents your session?

0 Answers  




What command is used to rename the database?

0 Answers  

How can sql server instances be hidden? : sql server security

0 Answers  

What is the difference between windows authentication and sql server authentication

7 Answers   HCL,

Can some one please help with a query which will take only max value of a column in a join.

2 Answers  

Can a cursor be updated? If yes, how you can protect which columns are updated?

0 Answers  

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

0 Answers  

How you trouble shoot when any job fails

0 Answers  

For more SQL Server Interview Questions Click Here
Categories