Database - SQL Server 2000 - Discussion
Discussion Forum : SQL Server 2000 - True or False (Q.No. 13)
13.
SQL Server supports three recovery modes: simple, full and Bulk.
Answer: Option
Explanation:
SQL Server provides three different recovery models that allow you to specify the way SQL Server manages log files and prepares your enterprise for a disaster. Each of these models represents a different approach to balancing the tradeoff between conserving disk space and providing for granular disaster recovery options. The three disaster recovery models offered by SQL Server are:
1. Simple Recovery Model
2. Full Recovery Model
3. Bulk-logged Recovery Model
Discussion:
1 comments Page 1 of 1.
Shipra Jain said:
1 decade ago
What about the differential recovery model?
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers