Restoring to a Point in Time
Databases in the full or bulk-logged recovery models can be restored to a point in time. This type of restore is similar to the point-of-failure scenario covered previously, but it allows for a more precise restore operation. These restores allow the database to be recovered to a time prior to a particular event. Malicious attacks or erroneous updates are some examples of events that would justify a point-in-time restore.
Note
There are some limitations on point-in-time restores of databases set to the bulk-logged recovery model. Point-in-time restores are not possible on transaction log backups that contain bulk load operations. Point-in-time restores can occur using transaction log backups that occurred prior to ...
Get Microsoft SQL Server 2014 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.
