Red Gate forums :: View topic - SQL Log Rescue - Current Version & Memory Problems
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

SQL Log Rescue - Current Version & Memory Problems

Search in SQL Log Rescue forum
Post new topic   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
owenh



Joined: 10 Aug 2005
Posts: 18

PostPosted: Mon Jan 30, 2006 5:51 pm    Post subject: SQL Log Rescue - Current Version & Memory Problems Reply with quote

I have recently upgraded my installations of SQLBAckup and SQLLogRescue on my Production Servers. SQLBackup seems to be running well, but I am experiencing problems with the SQL Log Rescue applicaiton.

First, the version from the About box for SQLLogRescue is 1.0.0.1044.

The database I am attempting to test with gives the following error:

Unable to connect to databse [(local)[Amx_QA] to retrieve backup files. Ensure you have access to the database.
Exception of type System.OutOfMemoryException was thrown.

I get the same error whether using an admin account or the "sa" account.

I ran this query :

SELECT distinct physical_device_name FROM msdb..backupmediafamily
WHERE media_set_id IN (SELECT media_set_id FROM msdb..backupset
WHERE database_name = N'Amx_QA' AND type LIKE '[LDI]'
AND database_creation_date IN (SELECT MAX(database_creation_date) FROM msdb..backupset WHERE database_name = N'Amx_QA')
) AND device_type IN (2,7,102)

And it returns 4287 rows.

Any suggestions?

Thanks.
Back to top
View user's profile Send private message AIM Address
Brian Donahue



Joined: 23 Aug 2004
Posts: 6580

PostPosted: Mon Jan 30, 2006 6:55 pm    Post subject: Reply with quote

Hello Owen,

Can you please try a beta of version 1.1 and see if that helps? There is a memory issue with 1.0 when your backup history is mega-huge. V1.1 will only retrieve a limited subset of the backup history and should fix the problem. You can download the fix from ftp://ftp.red-gate.com/SQLLogRescueSetup110Build204.zip
Back to top
View user's profile Send private message
owenh



Joined: 10 Aug 2005
Posts: 18

PostPosted: Mon Jan 30, 2006 8:15 pm    Post subject: Reply with quote

Thanks! I downloaded the beta as suggested and it seems to have resolved the issues.
Back to top
View user's profile Send private message AIM Address
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. 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