System.OutOfMemoryException

Undo for SQL Server.

Moderator: eddie davis

System.OutOfMemoryException

Postby stupy1 » Fri Jul 08, 2005 2:38 pm

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
stupy1
 
Posts: 4
Joined: Fri Jul 08, 2005 2:34 pm

Postby Daniel Handley » Mon Jul 11, 2005 1:59 pm

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
Daniel Handley
 
Posts: 198
Joined: Mon Feb 07, 2005 3:05 pm
Location: Red Gate Software

Postby dhammond » Fri Oct 07, 2005 4:52 pm

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
dhammond
 
Posts: 4
Joined: Fri Oct 07, 2005 4:43 pm

Postby Daniel Handley » Fri Oct 07, 2005 4:56 pm

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
Daniel Handley
 
Posts: 198
Joined: Mon Feb 07, 2005 3:05 pm
Location: Red Gate Software


Return to SQL Log Rescue

Who is online

Users browsing this forum: No registered users and 0 guests