Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL Server 2008 backups fail with SQLVDI error

Posted on 2014-02-11
4
Medium Priority
?
3,177 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 15

Assisted Solution

by:Deepak Chauhan
Deepak Chauhan earned 1500 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:
Deepak Chauhan earned 1500 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

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

715 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