Point-in-Time Recovery

Transaction logs can be restored through a date and a time that you specify. Transactions committed after that date and time will be rolled back.

Point-in-time recovery applies to transaction log restores only (not to full database or table restores.)

    To perform a point-in-time recovery

1. From SQL Enterprise Manager, in the Server Manager window select a server.
2. From the Tools menu, choose Database Backup/Restore.

   The Database Backup/Restore dialog box appears.

3. Select the Restore tab.
4. From the Database list, select the database to restore.
5. Under Backup History, select a backup from the Restore column, which displays backups that are available for the selected source database.
6. Select the Until Time option to restore a database through a specific time. Adjust the displayed time appropriately. Transactions committed after the specified time will be rolled back.
7. Choose Restore Now.

For more information about load options, see the online Help for Restoring a Database or a Transaction Log in SQL Enterprise Manager.

Point-in-time recovery can also be accomplished by using the Transact-SQL LOAD TRANSACTION statement with the STOPAT option. For more information, see What's New for Transact-SQL.