can you any body tell me simple recovery,full recovery,bulk
logged recovery where can use?
- 1 Answers
- 3290 Views
- I also Faced
- E-Mail Answers
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 different types of index?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
What is entity data services?
What are different backups available in sql server?
How to list all triggers in the database with sys.triggers in ms sql server?
What is filestream?
What is the difference between Triggers and Stored Procedure?
How can you find out how many rows returned in a cursor?
How do you create a clustered index?
What are .mdf files?
What are number line correlation administrators will use while working with a subquery?
what is the information that can be stored inside a bit column? : Sql server database administration
how you can get the list of largest tables in a database? : Sql server administration
What is standby servers? Explain types of standby servers.
What is the difference between NOROW and LOCKROW?
