can you any body tell me simple recovery,full recovery,bulk
logged recovery where can use?
Answer Posted / 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 View All Answers
Explain what are the database objects? : SQL Server Architecture
How would we use distinct statement? What is its use?
How to provide values to stored procedure parameters in ms sql server?
What are the types of normalization?
Can you please explain the difference between function and stored procedure?
Explain optimistic and pessimistic concurrency?
What are “lost updates”?
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
What is outer join in sql server joins?
What are the 10 characteristics of data quality?
What is the difference between osql and query analyzer?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
How can we call UDF(User Define Function) using C# code in ASP.net ?
What is dbcc?
Why use view instead of a table?