AppSync: SQL-gjenoppretting mislykkes på grunn av manglende LDF-filer (sql log).

本文适用于 本文不适用于 本文并非针对某种特定的产品。 本文并非包含所有产品版本。

症状



AppSync kan ikke gjenopprette en SQL-database på en mount host.

Serviceplan-hendelsene vil vise:
Unable to recover database MyDB on the instance MySQL-QA.  See the host plug-in log, application event log, and the SQL Server error log for details.

Hendelsesloggen for operativsystemet vil vise:
Error         Mountx 17207   MSSQLSERVER                      FileMgr::StartLogFiles: 
Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 
'L:\SourceFolder\MSSQL\logs\MyDB_2.ldf'. Diagnose and correct the operating system error, and retry the operation.

Error         Mountx 17207   MSSQLSERVER                      FileMgr::StartLogFiles:
 Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file
'L:\SourceFolder\MSSQL\logs\MyDB_3.ldf'. Diagnose and correct the operating system error, and retry the operation.

Loggen for AppSync-plugin-modulen på mount host vil vise:
[MountHost] SQL: Last native error: error number 5111, SQLState 01000, sql native info message [Microsoft][ODBC SQL Server Driver][SQL Server]File activation failure.
The physical file name "L:\SourceFolder\MSSQL\logs\MyDB_2.ldf" may be incorrect.
[MountHost] SQL: processSQLMessages: Message = Msg 1813, SevLevel 0, State 5, SQLState 42000, sql native info [Microsoft][ODBC SQL Server Driver][SQL Server]Could not open new database 'MyDB'. CREATE DATABASE is aborted.

[MountHost] SQL: Last native error: error number 5111, SQLState 01000, sql native info message [Microsoft][ODBC SQL Server Driver][SQL Server]File activation failure.
The physical file name    "L:\SourceFolder\MSSQL\logs\MyDB_3.ldf" may be incorrect.
[MountHost] SQL: processSQLMessages: Message = Msg 1813, SevLevel 0, State 5, SQLState 42000, sql native info [Microsoft][ODBC SQL Server Driver][SQL Server]Could not open new database 'MyDB'. CREATE DATABASE is aborted.

原因

Programvarefeil

解决方案

AppSync 4.0 løser dette problemet.

其他信息

Produktmerknadene for AppSync 4.0 nevner ikke at dette er løst i «Løst i»-delen, men det har blitt bekreftet at dette problemet er løst i AppSync 4.0
Oppgrader til AppSync 4.0 for å løse dette problemet.

受影响的产品

AppSync

产品

AppSync
文章属性
文章编号: 000170225
文章类型: Solution
上次修改时间: 20 10月 2025
版本:  6
从其他戴尔用户那里查找问题的答案
支持服务
检查您的设备是否在支持服务涵盖的范围内。