What is the simple 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 simple recovery model?
Rating:
The simple recovery model is the simplest form of recovery model as it requires least administrative efforts. The backup of transaction log is not required in this recovery model. When the simple recovery model is implemented on a database, it automatically truncates the transaction log backup. The database can be recovered only to the point it was last backed up. This model is appropriate for the read-only databases.
Rating:
Was this information helpful?
Other articles
- SQL Server 2000 and Security
- Things to practice for Microsoft test 70-228.
- What is RAID-1?
- What is INNER JOIN?
- What is failover clustering?