469,622 Members | 1,445 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,622 developers. It's quick & easy.

How to restore database to point in time (no full backup)

Database is OK. I just need to roll back all the transactions until certain
point in time. How to do it?
Jul 23 '05 #1
2 3052
Wit

If you don't have a database or log backup, you don't have much choice.

You have to understand what your transactions are doing and other
transactions are doing after "point in time". May be you have to write
your own script to roll backup the changes.

The thing I looked at before is Lumingent's Log explorer. But it is
very difficult to control if you don't even know what tables to
rollback.

Cheers
Norm
Wit Wiech wrote:
Database is OK. I just need to roll back all the transactions until certain point in time. How to do it?


Jul 23 '05 #2
You can't roll back a database to a point in time, only forwards. You
would need to restore a database backup from before that time, then
restore transaction log backups to roll forward to the time you want.
See "Recovering to a Point In Time" in Books Online.

Simon

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by ad | last post: by
1 post views Thread by Utahduck | last post: by
5 posts views Thread by Neil | last post: by
3 posts views Thread by Bill E. | last post: by
1 post views Thread by pinoy2ser | last post: by
reply views Thread by devrayhaan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.