Red Gate forums :: View topic - System.OutOfMemoryException
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

System.OutOfMemoryException

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



Joined: 08 Jul 2005
Posts: 7

PostPosted: Fri Jul 08, 2005 2:38 pm    Post subject: System.OutOfMemoryException Reply with quote

I just downloaded and installed the trial version of log rescue and on the select database window of the project settings I'm getting an out of memory exception error. Unable to connect to database..ensure you have access...

I have windows admin rights on the box. I also tried with the sql server authentication with the sa account and I get the same error.

any ideas?

thanks,

Justin
Back to top
View user's profile Send private message
Daniel Handley



Joined: 07 Feb 2005
Posts: 199
Location: Red Gate Software

PostPosted: Mon Jul 11, 2005 1:59 pm    Post subject: Reply with quote

Hi Justin

There are two causes for an out of memory problem.
The first is that there isn't enough physical memory to hold all the data imported from the back and file information.

The second is related to having a significantly large amount of backup information that is being pulled into the application.
To check for this please execute the following script and check if the out put is a large figure.
SELECT distinct physical_device_name FROM msdb..backupmediafamily

WHERE media_set_id IN (SELECT media_set_id FROM msdb..backupset WHERE database_name = N'XXXXXXXX' AND type LIKE '[LDI]'

AND database_creation_date IN (SELECT MAX(database_creation_date) FROM msdb..backupset

WHERE database_name = N'XXXXXXXX')

)

AND device_type IN (2,7,102)

Please replace the two instances of XXXXXXXX with the relevant database names.

We are working on this problem and it will be fixed in the next release.

Regards
Dan
_________________
Daniel Handley
Red Gate Software Ltd
Back to top
View user's profile Send private message Send e-mail
dhammond



Joined: 07 Oct 2005
Posts: 4

PostPosted: Fri Oct 07, 2005 4:52 pm    Post subject: Reply with quote

Any word on the status of this problem?

On a related note -- any tips on working around this problem by safely deleting backup history? (Our database seems to have backup history from the day it was created.)

Thanks!
- David
Back to top
View user's profile Send private message
Daniel Handley



Joined: 07 Feb 2005
Posts: 199
Location: Red Gate Software

PostPosted: Fri Oct 07, 2005 4:56 pm    Post subject: Reply with quote

Hi there is a patch i can send you if you contact support.

I also beleive there is some information about reducing your backup history in the SQL Backup forum.

Regadrs
Dan
_________________
Daniel Handley
Red Gate Software Ltd
Back to top
View user's profile Send private message Send e-mail
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