Export (0) Print
Expand All
0 out of 2 rated this helpful - Rate this topic

Restoring a Database to a Prior State

SQL Server 2000

At times, you may want to restore your database to an earlier point in time. For example, if an earlier transaction within a database changed some data incorrectly, you will need to restore the database to a point in time earlier than the incorrect data entry. To do this, recover the entire database to a point within a transaction log. You can recover a database to either a specific point in time within a transaction log or to a named mark that was previously inserted into the log.

To create a transaction log backup

Transact-SQL

Enterprise Manager

SQL-DMO

To backup the transaction log when the database is damaged

Transact-SQL

SQL-DMO

To restore to the point of failure

Transact-SQL

Enterprise Manager

SQL-DMO

See Also

BACKUP

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.