IBM Support

Microsoft SQL database backup can fail to copy mdf file to vSnap volume

Troubleshooting


Problem

Microsoft SQL database backup fails to copy mdf file from shadow copy volume to vSnap volume. The job log shows following error after data is transferred for a while:

CTGGA2653,<sql-instance> ==> <sql-db>([Backup failed: Group <sql-instance>\<sql-db> copy failed  message [Copy file from [\\?\GLOBALROOT\Device\HarddiskVolumeShadowCopyxxx\xxx\<sql-db>.mdf] to [c:\programdata\spp\mnt\sppb_spp_1000_2000_15f92ec4333e\<sql-instance>\<sql-db>\<sql-db>_mdf_20221205203354\<sql-db>.mdf] failed  [(2  The system cannot find the file specified.)]]])

Symptom

The Microsoft SQL database mdf file is transferred for a while until the IBM Spectrum Protect Plus SQL agent on the Microsoft SQL Server fails the copy to the iSCSI mounted vSnap volume.

Document Location

Worldwide


[{"Type":"MASTER","Line of Business":{"code":"LOB26","label":"Storage"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSNQFQ","label":"IBM Spectrum Protect Plus"},"ARM Category":[{"code":"a8m0z0000001jgyAAA","label":"Troubleshooting"}],"ARM Case Number":"TS010993917","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

To view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use the link to actual document below to access the full document. You will be asked to log on if you are not already logged in. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

More support for:
IBM Spectrum Protect Plus

Component:
Troubleshooting

Software version:
All Versions

Document number:
6844705

Modified date:
08 December 2022

UID

ibm16844705

Manage My Notification Subscriptions