How to restore to a point in time (Enterprise Manager)

How to Install SQL Server 2000

How To

How to restore to a point in time (Enterprise Manager)

To restore to a point in time

  1. Expand a server group, and then expand a server.

  2. Expand Databases, right-click the database, point to All Tasks, and then click Restore Database.

  3. In Restore as database, type or select the name of the database to restore, if different from the default.

  4. Click Database.

  5. In the First backup to restore list, click the backup set to restore.

  6. In the Restore list, select the database backup and one or more transaction logs to restore.

  7. Click Point in time restore, and then type values for Date and Time.

  8. Click the Options tab, and then click Leave database operational. No additional transaction logs can be restored.

See Also

Restoring a Database to a Prior State