Understanding the SQL Server Recover Models
There are three recovery models to choose from: Simple, Full, and Bulk-Logged. The choice of the model depends on various factors that need to be considered, such as the extent to which data loss is acceptable, performance of the SQL Server, and database recovery to the point of failure.
The simple recovery model recovers the database only to the point of the last successful full or differential backup. Content added to the database after the backup cannot be recovered with this model.
The full recovery model recovers the entire database to any point in time, because transaction logs are maintained. It must be noted that because all transactions to the database are logged, SQL Server database performance ...
Get Microsoft SharePoint 2010 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
