Troubleshooting
Problem
IBM Spectrum Protect Plus SQL database restore (using production method) can fail when it is configured with FILESTREAM.
Symptom
These errors are seen in the job log:
ERROR, ,CTGGE0087,[YOURSERVER] SQL restore failed error[Writer [SqlServerWriter] reported error status([VSS_WS_FAILED_AT_PRE_RESTORE] [13]) error message [(0x00000000 0000011214A8BCF0)]].
These errors are seen in the Application Windows Log:
Error,SQLVDI,1,None,SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Process=3600. Thread=9156. Client. Instance
="YOURINSTANCENAME". VD=Global\{25B3CD66-3081-4873-85F3-015982E4BE22}_SQLVDIMemoryName_0.
Error,SQLWRITER,24583,None,"Sqllib error: OLEDB Error encountered calling ICommandText::Execute. hr = 0x80040e14. SQLSTATE: 42000, N
ative Error: 3013
Error state: 1, Severity: 16
Source: Microsoft SQL Server Native Client 11.0
Error message: RESTORE DATABASE is terminating abnormally.
SQLSTATE: 42000, Native Error: 3119
Error state: 1, Severity: 16
Source: Microsoft SQL Server Native Client 11.0
Error message: Problems were identified while planning for the RESTORE statement. Previous messages provide details.
SQLSTATE: 42000, Native Error: 3156
Error state: 3, Severity: 16
Source: Microsoft SQL Server Native Client 11.0
Error message: The path specified by "YOUR_PATH_RESTORE":\...\"YOUR_DATABASE_NAME".filestream"YOURNAME"' is not in a valid directory.
SQLSTATE: 01000, Native Error: 5121
="YOURINSTANCENAME". VD=Global\{25B3CD66-3081-4873-85F3-015982E4BE22}_SQLVDIMemoryName_0.
Error,SQLWRITER,24583,None,"Sqllib error: OLEDB Error encountered calling ICommandText::Execute. hr = 0x80040e14. SQLSTATE: 42000, N
ative Error: 3013
Error state: 1, Severity: 16
Source: Microsoft SQL Server Native Client 11.0
Error message: RESTORE DATABASE is terminating abnormally.
SQLSTATE: 42000, Native Error: 3119
Error state: 1, Severity: 16
Source: Microsoft SQL Server Native Client 11.0
Error message: Problems were identified while planning for the RESTORE statement. Previous messages provide details.
SQLSTATE: 42000, Native Error: 3156
Error state: 3, Severity: 16
Source: Microsoft SQL Server Native Client 11.0
Error message: The path specified by "YOUR_PATH_RESTORE":\...\"YOUR_DATABASE_NAME".filestream"YOURNAME"' is not in a valid directory.
SQLSTATE: 01000, Native Error: 5121
Error,SQLVDI,1,None,SQLVDI: Loc=TriggerAbort. Desc=invoked. ErrorCode=(0). Process=3784. Thread=8216. Server. Instance="YOURINSTANCENAME". VD=Gl
obal\{25B3CD66-3081-4873-85F3-015982E4BE22}_SQLVDIMemoryName_0.
Error,None,"Volume Shadow Copy Service error: Unexpected error An older writer session state is being removed. . hr = 0x8
0042409, Writer status is not available for one or more writers. A writer may have reached the limit to the number of available backup-restore session s
tates.
obal\{25B3CD66-3081-4873-85F3-015982E4BE22}_SQLVDIMemoryName_0.
Error,None,"Volume Shadow Copy Service error: Unexpected error An older writer session state is being removed. . hr = 0x8
0042409, Writer status is not available for one or more writers. A writer may have reached the limit to the number of available backup-restore session s
tates.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB69","label":"Storage TPS"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSNQFQ","label":"IBM Spectrum Protect Plus"},"ARM Category":[{"code":"a8m0z0000001jgyAAA","label":"Troubleshooting"}],"ARM Case Number":"TS010356241","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions"}]
Log InLog in 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 Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
06 October 2022
UID
ibm16824231