Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL Server 2008 backups fail with SQLVDI error

Posted on 2014-02-11
4
Medium Priority
?
3,217 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 16

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 16

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone 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

One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how the fundamental information of how to create a table.

971 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