ExamVeda
Login
Home
This question belongs to Database SQL Server 2000
SQL Server 2000
?

SQL Server supports three recovery modes: simple, full and Bulk.

Answer & Solution
Correct Answer: Option A

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

Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.