Solved

SQL Server 2008 backups fail with SQLVDI error

Posted on 2014-02-11
4
3,020 Views
Last Modified: 2014-05-07
Hi there

Last week our backup of our Development server failed with a message I interpreted as "not enough room on disk to perform backup operation" I then freed up from 5GB available to 14GB available.

Backups ran for a week and then failed with same message.

I increased the drive to have 100+GB available - just to be done with it - making entire disk a 200GB drive.

Last night the backup failed again.

Digging further into the error messages I see the following to begin with:

Event Type:      Error
Event Source:      SQLVDI
Event Category:      None
Event ID:      1
Date:            2/11/2014
Time:            1:26:11 AM
User:            N/A
Computer:      CPHEBTDV01
Description:
SQLVDI: Loc=BufferAreaManager::MapBuffers. Desc=Out Of Address Space. ErrorCode=(8)Not enough storage is available to process this command.
. Process=2200. Thread=7836. Server. Instance=MSSQLSERVER. VD=Global\11437_eu_3litraapuhdastavettafi_00__a9f020b4_e54c_455a_9589_175a864e46f5__SQLVDIMemoryName_0.


Followed by this error message - note -  this error appears twice in a row!

Event Type:      Error
Event Source:      MSSQLSERVER
Event Category:      Server
Event ID:      18210
Date:            2/11/2014
Time:            1:26:11 AM
User:            EMEA\wuncph_backup
Computer:      CPHEBTDV01
Description:
BackupVirtualDeviceSet::SetBufferParms: Request large buffers failure on backup device '11437_eu_3litraapuhdastavettafi_00__a9f020b4_e54c_455a_9589_175a864e46f5_'. Operating system error 0x8007000e(Not enough storage is available to complete this operation.).


Next Event is this:

BACKUP failed to complete the command BACKUP DATABASE 11437_eu_3litraapuhdastavettafi. Check the backup application log for detailed messages.

If I go to the Backup server I see this Event after the backup finished:

Backup Exec Alert: Job Failed
(Server: "CPHEBTUT04") (Job: "WunCPH - Non FS-WunCPH Non-Fileservers-Daily Backup -Non FS") WunCPH - Non FS-WunCPH Non-Fileservers-Daily Backup -Non FS -- The job failed with the following error: Database Query Failure. See the job log for details.


Th Job log leads to this page:
http://www.symantec.com/business/support/index?page=content&id=TECH128837&actp=search&viewlocale=en_US&searchid=1392114943784

Which says to apply Hotfix to the server - But our SQL server is 2008 - not 2005 - so the Hotfix would not work on our SQL-server ( I did try just in case - and it reported "no valid SQL server installations found"


I can't see any other articles on Google that realte to this problem - that doesn't point to the hotfix above...

Any assistance would be greatly appreciated.

Best Regards
Thomas
0
Comment
Question by:Panthom
  • 2
  • 2
4 Comments
 
LVL 15

Assisted Solution

by:deepakChauhan
deepakChauhan earned 500 total points
ID: 39850756
Apply a HotFix is always not an appropriate solution. It might be possible, this server is in memory pressure at the time of backups or may be some memory consuming process running at the time of failure. So please do some more research on memory before applying any hotfix.

Please check this link also here is some reasons for the same.

http://www.sqlservercentral.com/blogs/sql_server_dba/2012/02/08/not-enough-storage-is-available-to-complete-this-operation/ 

http://www.sqlserver-dba.com/2011/06/sql-server-performance-memory-pressure-and-memory-usage.html
0
 

Author Comment

by:Panthom
ID: 39856108
Hi Deepak

Would a limit on the SQL server to 4GB of memory and then an increase from 4 to 5GB of RAM on the Server (VMware virtualized 2003 Server) do the trick then do you think?

Best Regards
Thomas
0
 
LVL 15

Accepted Solution

by:
deepakChauhan earned 500 total points
ID: 39862216
This is depend on the edition of windows server as windows server 2003 standard edition 32 bit system can support up to 4 gb of RAM. If it is then you can enable 4GT switch and configure AWE memory.


Following links can help you to configure memory as per your requirement.

http://support.microsoft.com/kb/283037.
http://technet.microsoft.com/en-us/library/ms190673(v=sql.105).aspx
0
 

Author Comment

by:Panthom
ID: 40047105
I upgraded the VM to have more memory - and the OS recognized it directly - so no need to tweak anymore than that.

Apologies for the late reply :/
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question