472,124 Members | 1,374 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,124 software developers and data experts.

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 3094
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 leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.