October 2010
Intermediate to advanced
1008 pages
46h 16m
English
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 ...
Read now
Unlock full access