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
What is the use of for clause?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
What are subqueries in sql server?
What is raid? : SQL Server Architecture
What is an index in sql?
What is the importance of concurrency control?
What is normalization? Describe its different types.
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
What is GUID in sql server?
How to change the data type of an existing column with "alter table" statements in ms sql server?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
Describe the functionalities that views support.
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
What is the xml datatype?