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



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 are various ways to enhance the ssrs report?

0 Answers  


what is the maximum size of a row? : Sql server database administration

0 Answers  


What is stored in the mssqlsystemresource database? : sql server database administration

0 Answers  


can we call functions from stored procedure in SQL Server 2005 ? How?

3 Answers  


Define candidate key, alternate key, composite key.

13 Answers   Infosys, Software India,






What specific conditions database should meet, before you can bulk copy data into it using bcp?

0 Answers  


Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000?

3 Answers   Infosys,


I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000

17 Answers   HCL, IBM,


What is attribute relationships, why we need it? : sql server analysis services, ssas

0 Answers  


Write a query to get all details of employee who has maximum salary from employee table

8 Answers   AON, Genpact,


Can sql server 2016 run on windows 7?

0 Answers  


Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?

1 Answers  


Categories