Panthom
asked on
SQL Server 2008 backups fail with SQLVDI error
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::Map Buffers. 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_3litraa puhdastave ttafi_00__ a9f020b4_e 54c_455a_9 589_175a86 4e46f5__SQ LVDIMemory Name_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::Se tBufferPar ms: Request large buffers failure on backup device '11437_eu_3litraapuhdastav ettafi_00_ _a9f020b4_ e54c_455a_ 9589_175a8 64e46f5_'. 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_3litraapuhdastave ttafi. 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
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::Map
. Process=2200. Thread=7836. Server. Instance=MSSQLSERVER. VD=Global\11437_eu_3litraa
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::Se
Next Event is this:
BACKUP failed to complete the command BACKUP DATABASE 11437_eu_3litraapuhdastave
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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 :/
Apologies for the late reply :/
ASKER
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