IBM Support

ANS1253E SQL database Instant Restore fails with RC 164

Troubleshooting


Problem

VSS Instant Restore of SQL database failing with error ANS1253E and RC=164

Symptom

The following error messages will appear in dsmerror.log
2014-12-09 14:21:32 FMV5250E An unexpected error was encountered.
FCM function name : psFileLock
FCM function : psFileLock(): Unable to lock volume: '1800', try = '10', error = '5'
FCM return code : 164
FCM file : ..\..\common\winnt\psfile.cpp (3140)
2014-12-09 14:21:32 FMV1050E The volume \test-abc\d$ could not be locked.
.
2014-12-09 14:21:32 FMV5250E An unexpected error was encountered.
FCM function name : UncfgVssVolumesBeforeSnapRestore
FCM function : psPrepareVolForSnapRestore() failed for volume '\\test-abc\d$'
FCM return code : 164
FCM file : ..\..\common\ba\restsnap.cpp (3220)
2014-12-09 14:21:32 FMV1050E The volume \test-abc\d$ could not be locked.
.

Cause

There are open file handles on the volume that VSS Instant Restore is attempting to restore.

Resolving The Problem

RC=164 indicates that there are open file handles on the volume where the VSS Instant Restore is being attempted. You must stop all applications that are accessing the volume being restored. VSS Instant Restore requires that the local disk is not being accessed by other applications, for example, MS
DOS windows, explorer, other databases....etc)

Related Information

[{"Product":{"code":"SS36V9","label":"Tivoli Storage FlashCopy Manager"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"FlashCopy Manager for Microsoft SQL Server","Platform":[{"code":"PF033","label":"Windows"}],"Version":"4.1;4.1.1","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Product Synonym

FCM TSM

Document Information

Modified date:
17 June 2018

UID

swg21696967