AppSync: SQL-Recovery schlägt aufgrund von fehlenden .ldf (SQL-Protokoll)-Dateien fehl
This article applies to
This article does not apply to
This article is not tied to any specific product.
Not all product versions are identified in this article.
Symptoms
AppSync schlägt bei der Recovery einer SQL-Datenbank auf einem Mount-Host fehl.
In den Serviceplan-Ereignissen wird Folgendes angezeigt:
Die Datenbank MyDB auf der Instanz MySQL-QA konnte nicht wiederhergestellt werden. Weitere Informationen finden Sie im Host-Plug-in-Protokoll, im Anwendungsereignis-Protokoll und im SQL-Server-Fehlerprotokoll.
Im Anwendungsereignis-Protokoll des Betriebssystems wird Folgendes angezeigt:
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.
Im AppSync-Plug-in-Protokoll auf dem Mount-Host wird Folgendes angezeigt:
[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.
Cause
Softwarefehler
Resolution
AppSync 4.0 löst dieses Problem.
Additional Information
In den AppSync-4.0-Versionshinweisen wird dieses Problem im Abschnitt „behobene Probleme“ nicht als behoben aufgeführt. Es wurde jedoch bestätigt, dass der Fehler in AppSync 4.0 behoben wurde.
Führen Sie ein Upgrade auf AppSync 4.0 durch, um dieses Problems zu beheben.
Führen Sie ein Upgrade auf AppSync 4.0 durch, um dieses Problems zu beheben.
Affected Products
AppSyncProducts
AppSyncArticle Properties
Article Number: 000170225
Article Type: Solution
Last Modified: 20 Oct 2025
Version: 6
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.