Simple Recovery Model in Microsoft SQL Server
Thursday January 1, 2009
The simple recovery model is just that: simple. In this approach, SQL Server maintains only a minimal amount of information in the transaction log. SQL Server truncates the transaction log each time the database reaches a transaction checkpoint, leaving no log entries for disaster recovery purposes.
In databases using the simple recovery model, you may restore full or differential backups only.
Read more about the simple recovery model and other options in SQL Server Recovery Models.
In databases using the simple recovery model, you may restore full or differential backups only.
Read more about the simple recovery model and other options in SQL Server Recovery Models.
Comments
It is really very important to repair the heap in order to access the data from damaged SQL Server. It can be done using the third party applications known as that is capable of addressing every problem of MDF corruption. Original SQL recovery is carried out by the software because of its read only and non destructive nature.