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 new security features added in sql server 2016? : sql server security
How do I create a trace in sql server?
Define Wed Edition in SQL Azure?
Is natural join and equi join same?
how to define testing of network layers? : Sql server database administration
Can coalesce return null?
what is the information that can be stored inside a bit column? : Sql server database administration
What are the types of user defined functions in sql server?
What is indexing and its types?
What is service broker?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
How to get the definition of a stored procedure back?
Explain alternate key, candidate key and composite key in sql server?
Do you know the cursor optimization tips?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration