Log Rescue crashed 2 boxes

Undo for SQL Server.

Log Rescue crashed 2 boxes

Postby rdalton » Tue Dec 20, 2005 8:44 pm

I downloaded the demo version of Log Rescue today. I tried to install it on my SQL box and it said I needed some .NET file updates so I installed it locally instead. I read in one of the other support messages, the program builds the files it needs locally so I copied the transaction logs I wanted to look at to my local computer. I then ran Log Rescue, connected to my sql server (2000), removed all backup from the list and added the files I copied. When I said run, it ran the first pop up that said opening and hung on analyzing. Eventually, the program timed out so I shut it down. About 10 minutes later, our SQL box crashed with a memory error.

I fugured there may have been a space constraint so I made a shell copy of the database and put it on another server. This had no data just all the structures. Again, it hung on analyzing and 10 minutes later, crashed the box.

The log file in question was about 18meg.

Again, according to your support forum, you should be building the files locally. It has no reason to crash the remote box. There is no option to open the files without connecting to a database or I would do that. I downloaded the files today and checked for updates and it found none.

I'm going to look for another tool. If you have an explanation, I would love to hear it. My company uses the Red Gate Sql Backup and have been happy with it but this is unbelievable.
rdalton
 
Posts: 25
Joined: Wed Oct 26, 2005 5:36 pm

Postby Brian Donahue » Wed Dec 21, 2005 11:53 am

Hello,

Apparently this could be some sort of problem with the extended stored procedure trying to obtain a file handle for the log file. Each time that an attempt is started to find the file handle, a thread is started to make sure that the attempt succeeds.

If you could send me an email, I can reply with a patched version of the software that limits the number of threads and fails more gracefully if the log file could not be opened.

Thanks!
Brian Donahue
 
Posts: 6590
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Log Rescue

Who is online

Users browsing this forum: No registered users and 1 guest