Red Gate forums :: View topic - Log Rescue Throwing Exceptions
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Log Rescue
SQL Log Rescue forum

Log Rescue Throwing Exceptions

Search in SQL Log Rescue forum
Post new topic   Reply to topic
Jump to:  
Author Message
mglenn



Joined: 13 Sep 2006
Posts: 16

PostPosted: Sat Sep 16, 2006 12:13 am    Post subject: Log Rescue Throwing Exceptions Reply with quote

Log Rescue 1.1.0.229
SQL Server 2000 SP4
Windows Server 2000 SP4
Server: 2 GB RAM; Dual Intel Xeon 2.0GHz
Database: 38 GB, Full recovery model; named instance
MDAC 2.8
.Net Framework 1.1

I created a recovery project and added 5 transaction logs (backed up hourly) plus the most recent full backup. There were no file warnings or errors. The analysis phase ran for approx. 18 minutes. Just as it approached 100% complete, Log Rescue threw the following Error:

RedGate.LogRescue.UI.exe Common Language Runtime Debugging Services
Application has generated an exception that could not be handled.
Process id=0xfac (4012), Thread id =0xd58 (3416)

Click OK to terminate...
Click Cancel to debug...

Notes: Log Rescue was run directly on the database server. Interactive user and batch processes were active at the time. Thinking this could be a factor I tried this again after users had gone home, but one batch still running. The result was another exception. Then I ran Log Rescue against the current transaction log on a test database (copy of the same database, but in Simple Recovery mode) and analysis completed successfully.

Is the lesson here to never use Log Rescue to analyze an active transaction log? Attempting recovery in an active database seems like a bad idea in any case, but do we also have to get everyone out and go into restricted access mode to view the transaction log?

Or maybe there's an entirely different reason for these exceptions...
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6643

PostPosted: Sat Sep 16, 2006 12:23 pm    Post subject: Reply with quote

Hi Mike,

There shouldn't really be a problem with analyzing a live database, in fact the live log is processed by Log Rescue, although it also processes log file backups in the same way.

If you are concerned about availability on a heavily-used database, though, I would think about grabbing the backups and restoring them to a testing server and analyzing the database on that server instead.
Back to top
View user's profile Send private message
mglenn



Joined: 13 Sep 2006
Posts: 16

PostPosted: Sun Sep 17, 2006 1:59 am    Post subject: Reply with quote

Okay, so what can we do about the errors?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6643

PostPosted: Tue Sep 19, 2006 12:26 pm    Post subject: Reply with quote

Hi Mike,

I haven't got any suggestions. Someone else is looking into possible causes for the error.
Back to top
View user's profile Send private message
mglenn



Joined: 13 Sep 2006
Posts: 16

PostPosted: Tue Sep 19, 2006 12:59 pm    Post subject: Reply with quote

Thanks. It is good to know I should normally have no problem analyzing an active database (other than contention).
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group