Solved

SQL Server 2008 backups fail with SQLVDI error

Posted on 2014-02-11
4
3,030 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:Deepak Chauhan
Deepak Chauhan 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:
Deepak Chauhan 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

808 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