Point-in-time recovery allows you to recover a database by rolling it forward to a particular time in its transaction log. You do this by using the until_time option of the load transaction command.
This feature is useful if, for example, a user inadvertently drops an important table from a database; you can use the until_time option to recover the changes to that database up to a time just before the table was dropped.
You can use point-in-time recovery for any database that can be loaded and dumped. However, you cannot use it for databases in which the data and logs are on the same device, such as the master database or for any database, such as tempdb, whose log has been truncated since the last dump database.
For more information on point-in-time recovery, see “Loading a Transaction Log to a Point in Time” on page 21-44 in the System Administration Guide and the load transaction command in the Adaptive Server Reference Manual.
