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

sql server architecture ?

0 Answers  


is it important for a database administrator to understand the operating system and file access? : Sql server administration

1 Answers  


You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

1 Answers  


What is the default value of CHAR type?

10 Answers   Bosch,


hi,i want t0 knom d syntax for a super key with an example

1 Answers  


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

0 Answers   Satyam,


How to use old values to define new values in update statements in ms sql server?

1 Answers  


What are the system database in sql server 2008?

1 Answers  


Differentiate between mongodb vs. Sql server?

1 Answers  


Find first and last day of current month in sql server

1 Answers  


Do you know what is replace and stuff function in sql server?

1 Answers  


What is the New in SQL server 2008?

1 Answers  


Categories