AppSync: SQL-återställning misslyckas på grund av att ldf-filer (sql-loggar) saknas.

Acest articol se aplică pentru Acest articol nu se aplică pentru Acest articol nu este legat de un produs specific. Acest articol nu acoperă toate versiunile de produs existente.

Symptoms



AppSync misslyckas med att återställa en SQL-databas på en monteringsvärd.

I serviceplanhändelserna visas följande:
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.

I programhändelseloggen för operativsystemet visas följande:
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.

I AppSync-insticksprogramloggen på monteringsvärden visas följande:
[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.

Cause

Programvarufel

Resolution

AppSync 4.0 löser problemet.

Additional Information

I AppSync 4.0-versionskommentarerna anges inte att det här problemet har åtgärdats i avsnittet för åtgärdade problem, men det har bekräftats att problemet har åtgärdats i AppSync 4.0
Uppgradera till AppSync 4.0 för att lösa problemet.

Produse afectate

AppSync

Produse

AppSync
Proprietăți articol
Article Number: 000170225
Article Type: Solution
Ultima modificare: 20 oct. 2025
Version:  6
Găsiți răspunsuri la întrebările dvs. de la alți utilizatori Dell
Servicii de asistență
Verificați dacă dispozitivul dvs. este acoperit de serviciile de asistență.