can you any body tell me simple recovery,full recovery,bulk logged recovery wh

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

Question Posted / prasadhari_m@yahoo.com

1 Answers
3877 Views
I also Faced
E-Mail Answers

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

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 the use of containers in ssis and also their types?

0 Answers

There is a table1 with records (1,2,3,4,5,6) and table2 with records (4,5,6,7,8,9).write a query so as to get the result as 1,2,3,4,5,6,7,8,9

12 Answers RBS,

What is SubQuery in SQL Server 2008

0 Answers HCL,

Different Types of Functions ?

2 Answers Satyam,

What do you understand by the data quality services in sql server?

0 Answers

What is mscorsvw.exe - process - microsoft .net framework ngen?

0 Answers

What is the main purpose of having conversation group?

0 Answers

How many levels of sp nesting are possible?

0 Answers

What is the difference between insensitive and scroll cursor?

0 Answers

What is the difference between a check constraint and a rule?

0 Answers

What are the two modes of authentication in sql server?

0 Answers

Explain full-text query in sql server?

0 Answers

For more SQL Server Interview Questions Click Here