Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 how to undo changes in a db (by using logs) ...

Author  Topic 

fabianus76
Posting Yak Master

191 Posts

Posted - 2007-12-09 : 18:34:35
Hello !

I have a big problem. I need to go back un changes that had been since the a specific date (beginning of november in my case).

Thanks a lot for any help on how to do this !

Regards,
Fabianus

my favorit hoster is ASPnix : www.aspnix.com !

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-09 : 20:13:53
Restore the db to that point, or use third party tools if the db is not in simple recovery model and you have all log backup files since that time.
Go to Top of Page

fabianus76
Posting Yak Master

191 Posts

Posted - 2007-12-09 : 22:25:28
Hi rmiao,

thanks for your suggestions. When you say "restore", this means that I need a backup that was done at that moment, right? I do not have any backup of that moment ...
Now concerning third party tools, do you have any suggestion?

Thanks for any further advice !

Regards,
Fabianus

my favorit hoster is ASPnix : www.aspnix.com !
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-09 : 22:51:09
Try Lumigent's Log Explorer, but those tools will not help you if the db is in simple recovery model.
Go to Top of Page

fabianus76
Posting Yak Master

191 Posts

Posted - 2007-12-10 : 06:38:30
Hi rmiao,

Why will simple recovery model not help? I thought that simple recovery model always keeps the logs since the last backup (which would be enough in this case).

Thanks for your feedback.

Yours,
Fabian

my favorit hoster is ASPnix : www.aspnix.com !
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-12-10 : 11:07:58
That is not the case with SIMPLE recovery model. The data is cleared from the transaction log after the transaction completes. Please read about the different recovery models in SQL Server Books Online.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

fabianus76
Posting Yak Master

191 Posts

Posted - 2007-12-11 : 09:07:23
Thanks tkizer !

Regards,
Fabianus

my favorit hoster is ASPnix : www.aspnix.com !
Go to Top of Page
   

- Advertisement -