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.
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, Fabianusmy 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. |
|
|
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, Fabianusmy favorit hoster is ASPnix : www.aspnix.com ! |
|
|
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. |
|
|
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, Fabianmy favorit hoster is ASPnix : www.aspnix.com ! |
|
|
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 KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
fabianus76
Posting Yak Master
191 Posts |
Posted - 2007-12-11 : 09:07:23
|
Thanks tkizer !Regards, Fabianusmy favorit hoster is ASPnix : www.aspnix.com ! |
|
|
|
|
|