May 13, 2005 at 1:45 pm
one of my database tranlog backup fails saying :
We use SqlSafe for backup.
errorlog : Operating system error 0x80070008(Not enough storage is available to process this command.).
Thanks in advance for the help.
May 13, 2005 at 2:21 pm
Sounds like a call to Idera Customer Support is in order. I'd be interested in hearing the resolution, though. I'm currently testing SQL Safe, and we're considering purchasing.
Steve
May 13, 2005 at 3:35 pm
Whenever dealing with a 3rd party backup product it is always helpful to determine if the error is related to SQL Server or the 3rd party product itself. In order to determin this, simply perform a native backup to the same backup device and see if it is successful or not. If the native backup is successful you have isolated SQL Safe as the cause of the issue. If the native backup is not successful you can rule out SQL Safe and should look at SQL Server, Operating System, or Hardware as the root cause of the issue.
May 27, 2005 at 1:15 pm
FYI server reboot solved the problem.
Thanks all for your help!
March 9, 2006 at 1:47 pm
It was due to fragmented MemToLeave space (non buffer pool) all backup products that use VDI can fall victim to this. It is usually caused by third party extended stored procedures or using the sp_OA* ole automation stored procs. A server restart(sql server service) is usually the only way to fix it. you can use the -g switch in the startup paramaters and set the MTL space larger by default is is 256MB I would try 512MB and see if that cuts down on your number of reboots.
Wes
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply