Solved

SQL Server 2008 backups fail with SQLVDI error

Posted on 2014-02-11
4
2,995 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
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…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

911 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now