Jump to content


Photo

SQL Database Backup - Error Opening Object

SQL Error Opening Object

  • Please log in to reply
2 replies to this topic

#1 Hugo Costa

Hugo Costa
  • Members
  • 2 posts

Posted 16 January 2020 - 07:18 AM

Hi All,

 

I was trying to run a SQL database backup on a server. The backup fails with the error "Error Opening Object".

 

I did some investigation on the logs of the agent and I found the following:

 

12/11/2019 09:29:00 0x00010ea8 YSqlObject j0: o12: Caught exception while trying to determine if descriptor: path: '\\?\GLOBALROOT\Device\HarddiskVolumeShadowCopy3380\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Log' descriptor: Match:Exact (DEXARNETHR_Content_log.ldf) false, m_recursionType: 'nonrecursive', m_selectionType: 'exclude', m_reportExclude: true, m_explicitSelection: false is on removable volume. e: Exception - Description: Parameter is invalid (Unable to determine volume for mountPath: \\?\GLOBALROOT\Device\HarddiskVolumeShadowCopy3380 normalizedNtPath: \Device\HarddiskVolumeShadowCopy3380) Original: 212 Mapped: 212 Location: Backup::Volume::YVolumeManager::GetUniquePathFromMountPoint:C:\jenkins\workspace\bbs_new_agent_win\backupagentapp\Backup\Volume\Windows\YVolumeManager.cpp:1996
12/11/2019 09:29:00 0x00010ea8 Critical: Exception - Description: Parameter is invalid (Unable to determine volume for mountPath: \\?\GLOBALROOT\Device\HarddiskVolumeShadowCopy3379 normalizedNtPath: \Device\HarddiskVolumeShadowCopy3379) Original: 212 Mapped: 212 Location: Backup::Volume::YVolumeManager::GetUniquePathFromMountPoint:C:\jenkins\workspace\bbs_new_agent_win\backupagentapp\Backup\Volume\Windows\YVolumeManager.cpp:1996
12/11/2019 09:29:00 0x00010ea8 YSqlObject j0: o12: Caught exception while trying to determine if descriptor: path: '\\?\GLOBALROOT\Device\HarddiskVolumeShadowCopy3379\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Data' descriptor: Match:Exact (DEXARNETHR_Content.mdf) false, m_recursionType: 'nonrecursive', m_selectionType: 'exclude', m_reportExclude: true, m_explicitSelection: false is on removable volume. e: Exception - Description: Parameter is invalid (Unable to determine volume for mountPath: \\?\GLOBALROOT\Device\HarddiskVolumeShadowCopy3379 normalizedNtPath: \Device\HarddiskVolumeShadowCopy3379) Original: 212 Mapped: 212 Location: Backup::Volume::YVolumeManager::GetUniquePathFromMountPoint:C:\jenkins\workspace\bbs_new_agent_win\backupagentapp\Backup\Volume\Windows\YVolumeManager.cpp:1996
12/11/2019 09:29:00 0x00010ea8 Critical: Exception - Description: Parameter is invalid (Unable to determine volume for mountPath: \\?\GLOBALROOT\Device\HarddiskVolumeShadowCopy3380 normalizedNtPath: \Device\HarddiskVolumeShadowCopy3380) Original: 212 Mapped: 212 Location: Backup::Volume::YVolumeManager::GetUniquePathFromMountPoint:C:\jenkins\workspace\bbs_new_agent_win\backupagentapp\Backup\Volume\Windows\YVolumeManager.cpp:1996
12/11/2019 09:29:00 0x00010ea8 YSqlObject j0: o13: Caught exception while trying to determine if descriptor: path: '\\?\GLOBALROOT\Device\HarddiskVolumeShadowCopy3380\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Log' descriptor: Match:Exact (DEXARNETHR_Content_log.ldf) false, m_recursionType: 'nonrecursive', m_selectionType: 'exclude', m_reportExclude: true, m_explicitSelection: false is on removable volume. e: Exception - Description: Parameter is invalid (Unable to determine volume for mountPath: \\?\GLOBALROOT\Device\HarddiskVolumeShadowCopy3380 normalizedNtPath: \Device\HarddiskVolumeShadowCopy3380) Original: 212 Mapped: 212 Location: Backup::Volume::YVolumeManager::GetUniquePathFromMountPoint:C:\jenkins\workspace\bbs_new_agent_win\backupagentapp\Backup\Volume\Windows\YVolumeManager.cpp:1996
12/11/2019 09:29:00 0x00010ea8 Critical: Exception - Description: Parameter is invalid (Unable to determine volume for mountPath: \\?\GLOBALROOT\Device\HarddiskVolumeShadowCopy3379 normalizedNtPath: \Device\HarddiskVolumeShadowCopy3379) Original: 212 Mapped: 212 Location: Backup::Volume::YVolumeManager::GetUniquePathFromMountPoint:C:\jenkins\workspace\bbs_new_agent_win\backupagentapp\Backup\Volume\Windows\YVolumeManager.cpp:1996
12/11/2019 09:29:00 0x00010ea8 YSqlObject j0: o13: Caught exception while trying to determine if descriptor: path: '\\?\GLOBALROOT\Device\HarddiskVolumeShadowCopy3379\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Data' descriptor: Match:Exact (DEXARNETHR_Content.mdf) false, m_recursionType: 'nonrecursive', m_selectionType: 'exclude', m_reportExclude: true, m_explicitSelection: false is on removable volume. e: Exception - Description: Parameter is invalid (Unable to determine volume for mountPath: \\?\GLOBALROOT\Device\HarddiskVolumeShadowCopy3379 normalizedNtPath: \Device\HarddiskVolumeShadowCopy3379) Original: 212 Mapped: 212 Location: Backup::Volume::YVolumeManager::GetUniquePathFromMountPoint:C:\jenkins\workspace\bbs_new_agent_win\backupagentapp\Backup\Volume\Windows\YVolumeManager.cpp:1996
12/11/2019 09:29:00 0x00010ea8 Critical: Exception - Description: Parameter is invalid (Unable to determine volume for mountPath: \\?\GLOBALROOT\Device\HarddiskVolumeShadowCopy3380 normalizedNtPath: \Device\HarddiskVolumeShadowCopy3380) Original: 212 Mapped: 212 Location: Backup::Volume::YVolumeManager::GetUniquePathFromMountPoint:C:\jenkins\workspace\bbs_new_agent_win\backupagentapp\Backup\Volume\Windows\YVolumeManager.cpp:1996
12/11/2019 09:29:00 0x00010ea8 YSqlObject j0: o14: Caught exception while trying to determine if descriptor: path: '\\?\GLOBALROOT\Device\HarddiskVolumeShadowCopy3380\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Log' descriptor: Match:Exact (DEXARNETHR_Content_log.ldf) false, m_recursionType: 'nonrecursive', m_selectionType: 'exclude', m_reportExclude: true, m_explicitSelection: false is on removable volume. e: Exception - Description: Parameter is invalid (Unable to determine volume for mountPath: \\?\GLOBALROOT\Device\HarddiskVolumeShadowCopy3380 normalizedNtPath: \Device\HarddiskVolumeShadowCopy3380) Original: 212 Mapped: 212 Location: Backup::Volume::YVolumeManager::GetUniquePathFromMountPoint:C:\jenkins\workspace\bbs_new_agent_win\backupagentapp\Backup\Volume\Windows\YVolumeManager.cpp:1996
12/11/2019 09:29:00 0x00010ea8 Critical: Exception - Description: Parameter is invalid (Unable to determine volume for mountPath: \\?\GLOBALROOT\Device\HarddiskVolumeShadowCopy3379 normalizedNtPath: \Device\HarddiskVolumeShadowCopy3379) Original: 212 Mapped: 212 Location: Backup::Volume::YVolumeManager::GetUniquePathFromMountPoint:C:\jenkins\workspace\bbs_new_agent_win\backupagentapp\Backup\Volume\Windows\YVolumeManager.cpp:1996
12/11/2019 09:29:00 0x00010ea8 YSqlObject j0: o14: Caught exception while trying to determine if descriptor: path: '\\?\GLOBALROOT\Device\HarddiskVolumeShadowCopy3379\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Data' descriptor: Match:Exact (DEXARNETHR_Content.mdf) false, m_recursionType: 'nonrecursive', m_selectionType: 'exclude', m_reportExclude: true, m_explicitSelection: false is on removable volume. e: Exception - Description: Parameter is invalid (Unable to determine volume for mountPath: \\?\GLOBALROOT\Device\HarddiskVolumeShadowCopy3379 normalizedNtPath: \Device\HarddiskVolumeShadowCopy3379) Original: 212 Mapped: 212 Location: Backup::Volume::YVolumeManager::GetUniquePathFromMountPoint:C:\jenkins\workspace\bbs_new_agent_win\backupagentapp\Backup\Volume\Windows\YVolumeManager.cpp:1996
 

I checked the Writers of the server and everything is stable and without errors. Also, I checked the VSS and there are no Volume Shadow Copies on this server. I checked Event viewer of the server and I found the event 8193, VSS basically saying the same as the barracuda logs.

 

Any idea about what is the issue here?

 

Thank you



#2 Hendrik Hirsch

Hendrik Hirsch
  • Barracuda Team Members
  • 46 posts
  • LocationInnsbruck

Posted 16 January 2020 - 07:21 AM

Hi Hugo, 

 

we do have a campus article for this Event ID. Kindly see: https://campus.barra...8193-diff-area/

It appears that the Diff Area for the Shadow copies cannot get big enough. 

 

Cheers

Hendrik  


Barracuda Networks

EMEA Presales Systems Engineer - Data Protection

 


#3 Hugo Costa

Hugo Costa
  • Members
  • 2 posts

Posted 16 January 2020 - 07:30 AM

Hi Hendrik,

 

My Event ID is the 8193 but the message is different:

 

Volume Shadow Copy Service error: Unexpected error calling routine GetVolumePathName is fail on the path \\?\GLOBALROOT\Device\harddiskVolumeShadowCopy3379\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Data, winerror 0x0000007b.. hr= 0x8007007b, The Filename, directory name, or volume label syntax is incorrect.

 

When I run "vssadmin list shadows" I get the output "No items found that satisfy the query"

 

Thank you,

Hugo