SQL事务日志卷上的卷影副本导致SQL Server脱机
适用场景
适用于SQL的SnapCenter插件(SCSQL)
问题描述
- 在备份期间广泛使用SQL VSS代理。
- SQL事务日志卷上的卷影副本填满了该卷、从而导致该卷脱机、SQL Server崩溃、并且""
SqlServerWriter不会处于故障状态。
C:\WINDOWS\system32\vssadmin list writersvssadmin 1.1 - Volume Shadow Copy Service administrative command-line tool(C) Copyright 2001-2013 Microsoft Corp.Writer name: 'SqlServerWriter' Writer Id: {a65faa63-5ea8-4ebc-9dbd-a0c4db26912a} Writer Instance Id: {2a0ccc8e-b187-4a5b-9778-4dd105f76d76} State: [10] Failed Last error: Timed out- 由于以下错误、无法删除受影响驱动器上的卷影副本：
C:\WINDOWS\system32\vssadmin delete shadows /for=i:vssadmin 1.1 - Volume Shadow Copy Service administrative command-line tool(C) Copyright 2001-2013 Microsoft Corp.Error: Snapshots were found, but they were outside of your allowed context.Try removing them with the backup application which created them.