AppSync: ldf(sql 로그) 파일 누락으로 SQL 복구 실패
本文适用于
本文不适用于
本文并非针对某种特定的产品。
本文并非包含所有产品版本。
症状
AppSync를 실행해도 Mount 호스트에서 SQL 데이터베이스가 복구되지 않습니다.
Service Plan 이벤트에 다음이 표시됩니다.
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.
Operating Systems Application Event 로그에 다음이 표시됩니다.
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.
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.
Mount 호스트의 AppSync Plugin 로그에 다음이 표시됩니다.
[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.
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.
原因
소프트웨어 버그
解决方案
AppSync 4.0에서 이 문제가 해결됩니다.
其他信息
AppSync 4.0 릴리스 노트에는 이 문제가 수정된 섹션에서 해결된 것으로 언급되어 있지 않지만, 이 문제가 AppSync 4.0에서 해결된 것으로 확인되었습니다.
AppSync 4.0으로 업그레이드하면 이 문제가 해결됩니다.
AppSync 4.0으로 업그레이드하면 이 문제가 해결됩니다.
受影响的产品
AppSync产品
AppSync文章属性
文章编号: 000170225
文章类型: Solution
上次修改时间: 20 10月 2025
版本: 6
从其他戴尔用户那里查找问题的答案
支持服务
检查您的设备是否在支持服务涵盖的范围内。