What is the full recovery model?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is the full recovery model?
Rating:
The full recovery model is used to prevent data loss during the recovery process. It requires the database backup and the transaction log. It also provides protection against media failure. It logs all the transactions and retains the transaction log. The transaction log should be stored on a fault-tolerant volume to prevent data loss.
Rating:
Was this information helpful?
Other articles
- What are articles?
- What is EventClass?
- What is a dirty read?
- What is MBSA tool?
- What is Service Broker?
