知识库 - Acronis

历史

王兴达 2023-11-23 上午10:23

差异

History → Now CHANGED

@@ -42,14 +42,14 @@
    Command Line: ""C:\Program Files\Microsoft SQL Server\90\Shared\sqlwriter.exe""
    Process ID: 1980"
 ```
 # 解决方法
-增加 SQL 服务器的最大工作线程数。选择您的 SQL 服务器版本，并按照此 [MSDN ](https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-max-worker-threads-server-configuration-option?view=sql-server-ver16&redirectedfrom=MSDN)文章的说明操作。
+增加 SQL Server 上的最大工作线程数。选择您的 SQL  Server 版本，并按照此 [MSDN ](https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-max-worker-threads-server-configuration-option?view=sql-server-ver16&redirectedfrom=MSDN)文章中的说明进行操作。
 # 案例2
 1.您正在使用磁盘级备份计划。
-2.您有ACT7！已安装SQL Server。
+2.您安装了 SQL Server (ACT7)
 3.在 Windows 应用程序事件日志中，您会看到以下错误：
 ```
 MS SQL Backup Fails with error: VSS error 0x800423f4
 Description

旧内容

内容

# 问题现象（介绍）
备份失败并显示以下信息：
```
| error 0x10c469: VSS writer 'SqlServerWriter' with class ID 'A65FAA63-5EA8-4EBC-9DBD-A0C4DB26912A' has failed to process the snapshot. To troubleshoot VSS issues, download and run Acronis VSS Doctor available at https://www.acronis.com/en-us/personal/vss-diagnostic-free-tool/
| line: 0x3fec04e376b89db2
| file: d:\602\core\fdisk\win_snapshot.cpp:188
| function: `anonymous-namespace'::ObtainVSSFailReasonSuberror
| writerName: SqlServerWriter
| writerID: A65FAA63-5EA8-4EBC-9DBD-A0C4DB26912A
| $module: disk_bundle_vsa64_29439
|
| error 0xfff0
| line: 0xbd28fdbd64edb902
| file: d:\602\core\common\error.cpp:324
| function: Common::Error::AddHResult
| code: 0x800423f4
| $module: disk_bundle_vsa64_29439
```
# 案例1
1.您有一个包含大量数据库的 SQL 实例。
2.您正在备份实例（或是备份包含实例的磁盘）。
3.在 Windows 应用程序事件日志中，您会看到以下错误：
```
"Sqllib error: OLEDB Error encountered calling ICommandText::Execute. hr = 0x80040e14. SQLSTATE: 42000, Native Error: 3013Error state: 1, Severity: 16
Source: Microsoft SQL Server Native Client 11.0
Error message: BACKUP DATABASE is terminating abnormally.
SQLSTATE: 42000, Native Error: 3202
Error state: 1, Severity: 16
Source: Microsoft SQL Server Native Client 11.0
Error message: Write on ""{56EFEAC3-AC01-4E93-86B8-D24E27241B1D}33"" failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.)

"A VSS writer has rejected an event with error 0x800423f4, The writer experienced a non-transient error.  If the backup process is retried,
the error is likely to reoccur. Changes that the writer made to the writer components while handling the event will not be available to the requester. Check the event log for related events from the application hosting the VSS writer.
Operation:
   PrepareForSnapshot Event
Context:
   Execution Context: Writer
   Writer Class Id: {a65faa63-5ea8-4ebc-9dbd-a0c4db26912a}
   Writer Name: SqlServerWriter
   Writer Instance Name: Microsoft SQL Server 2014:SQLWriter
   Writer Instance ID: {3a6cb2be-ba9b-4259-9a73-59d16eff7f93}
   Command Line: ""C:\Program Files\Microsoft SQL Server\90\Shared\sqlwriter.exe""
   Process ID: 1980"
```
# 解决方法
增加 SQL 服务器的最大工作线程数。选择您的 SQL 服务器版本，并按照此 [MSDN ](https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-max-worker-threads-server-configuration-option?view=sql-server-ver16&redirectedfrom=MSDN)文章的说明操作。 


# 案例2
1.您正在使用磁盘级备份计划。
2.您有ACT7！已安装SQL Server。
3.在 Windows 应用程序事件日志中，您会看到以下错误：
```
MS SQL Backup Fails with error: VSS error 0x800423f4
Description
MS SQL Backup Fails with error: VSS error 0x800423f4
Act7 Database
Errors in Event Logs:
SQLVDI - Loc=UserAccount::Init(name). Desc=LookupAccountName. ErrorCode=(1332)No mapping between account names and security IDs was done Instance=ACT7
SQLVDI - Loc=IdentifySQLServer. Desc=Initialize. ErrorCode=(1332)No mapping between account names and security IDs was done Instance=ACT7
SQLWRITER - Sqllib error: Failed to create VDS object. hr=0x80770005
```
# 解决方法
将 SQL Server(ACT7) 服务用户更改为本地服务：
1.右键 "开始 "菜单。
2.选择计算机管理。
3.选择服务和应用程序。
4.选择 SQL Server 配置管理器。
5.找到 SQL Server (ACT7)。
6.将服务登录从“本地系统”更改为“本地服务”。
7.重新启动计算机。

# 更多信息
使用[免费的 Acronis VSS Doctor工具](https://www.acronis.com/en-us/products/vss-doctor/) 排除其他 VSS 相关问题。



原文链接：https://kb.acronis.com/content/57072

新内容

内容

# 问题现象（介绍）
备份失败并显示以下信息：
```
| error 0x10c469: VSS writer 'SqlServerWriter' with class ID 'A65FAA63-5EA8-4EBC-9DBD-A0C4DB26912A' has failed to process the snapshot. To troubleshoot VSS issues, download and run Acronis VSS Doctor available at https://www.acronis.com/en-us/personal/vss-diagnostic-free-tool/
| line: 0x3fec04e376b89db2
| file: d:\602\core\fdisk\win_snapshot.cpp:188
| function: `anonymous-namespace'::ObtainVSSFailReasonSuberror
| writerName: SqlServerWriter
| writerID: A65FAA63-5EA8-4EBC-9DBD-A0C4DB26912A
| $module: disk_bundle_vsa64_29439
|
| error 0xfff0
| line: 0xbd28fdbd64edb902
| file: d:\602\core\common\error.cpp:324
| function: Common::Error::AddHResult
| code: 0x800423f4
| $module: disk_bundle_vsa64_29439
```
# 案例1
1.您有一个包含大量数据库的 SQL 实例。
2.您正在备份实例（或是备份包含实例的磁盘）。
3.在 Windows 应用程序事件日志中，您会看到以下错误：
```
"Sqllib error: OLEDB Error encountered calling ICommandText::Execute. hr = 0x80040e14. SQLSTATE: 42000, Native Error: 3013Error state: 1, Severity: 16
Source: Microsoft SQL Server Native Client 11.0
Error message: BACKUP DATABASE is terminating abnormally.
SQLSTATE: 42000, Native Error: 3202
Error state: 1, Severity: 16
Source: Microsoft SQL Server Native Client 11.0
Error message: Write on ""{56EFEAC3-AC01-4E93-86B8-D24E27241B1D}33"" failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.)

"A VSS writer has rejected an event with error 0x800423f4, The writer experienced a non-transient error.  If the backup process is retried,
the error is likely to reoccur. Changes that the writer made to the writer components while handling the event will not be available to the requester. Check the event log for related events from the application hosting the VSS writer.
Operation:
   PrepareForSnapshot Event
Context:
   Execution Context: Writer
   Writer Class Id: {a65faa63-5ea8-4ebc-9dbd-a0c4db26912a}
   Writer Name: SqlServerWriter
   Writer Instance Name: Microsoft SQL Server 2014:SQLWriter
   Writer Instance ID: {3a6cb2be-ba9b-4259-9a73-59d16eff7f93}
   Command Line: ""C:\Program Files\Microsoft SQL Server\90\Shared\sqlwriter.exe""
   Process ID: 1980"
```
# 解决方法
增加 SQL Server 上的最大工作线程数。选择您的 SQL  Server 版本，并按照此 [MSDN ](https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-max-worker-threads-server-configuration-option?view=sql-server-ver16&redirectedfrom=MSDN)文章中的说明进行操作。 


# 案例2
1.您正在使用磁盘级备份计划。
2.您安装了 SQL Server (ACT7)
3.在 Windows 应用程序事件日志中，您会看到以下错误：
```
MS SQL Backup Fails with error: VSS error 0x800423f4
Description
MS SQL Backup Fails with error: VSS error 0x800423f4
Act7 Database
Errors in Event Logs:
SQLVDI - Loc=UserAccount::Init(name). Desc=LookupAccountName. ErrorCode=(1332)No mapping between account names and security IDs was done Instance=ACT7
SQLVDI - Loc=IdentifySQLServer. Desc=Initialize. ErrorCode=(1332)No mapping between account names and security IDs was done Instance=ACT7
SQLWRITER - Sqllib error: Failed to create VDS object. hr=0x80770005
```
# 解决方法
将 SQL Server(ACT7) 服务用户更改为本地服务：
1.右键 "开始 "菜单。
2.选择计算机管理。
3.选择服务和应用程序。
4.选择 SQL Server 配置管理器。
5.找到 SQL Server (ACT7)。
6.将服务登录从“本地系统”更改为“本地服务”。
7.重新启动计算机。

# 更多信息
使用[免费的 Acronis VSS Doctor工具](https://www.acronis.com/en-us/products/vss-doctor/) 排除其他 VSS 相关问题。



原文链接：https://kb.acronis.com/content/57072