News

In addition, there isn’t a need for point-in-time or up-to-the-minute restores.For more information on recovery models review chapter 3, “Administering SQL Server 2005 Database Engine” on my ...
If you put your databases in Simple Recovery Model, it tells the SQL Server CHECKPOINT process to write the transactions from the T-log to the data file and after a successful write, to purge them ...
No recovery up to the point of failure as with the Full recovery model. You see, we cannot use the transaction log for recovery with the Simple recovery model.