Hello everyone, I ran into an issue when trying to restore SQL Server 2019 using Vinchin. Details are as follows:
Problem Description:
I backed up the master database in SQL Server 2019 and attempted an original path restore. However, the WEB console reported error #1 and #46, and the restore failed.
Error Logs:
WEB side:
Error restoring database 'master', error code: '',[#1]Failed
Job failed,[#46]Job error
Server side (/var/log/vinchin/db_server/db_server-2023-03-16.log):
[ERROR: 1#Generic error]:
Task<5efd346d-3a10-4203-ac53-05fb8856587f> some thread error, backup db_name: MSSQLSERVER. db_backup_server_task/db_backup_server_task.cpp: 4901, StartAndWaitRecoveryTransThreads
[ERROR: 1#Generic error]:
Task<5efd346d-3a10-4203-ac53-05fb8856587f> start and wait all backup thread error, db_name: master. db_backup_server_task/sqlserver_task/sql_server_task.cpp: 1079, DoDbRecovery
Has anyone encountered a similar issue? Is this because the master system database cannot be restored in the same way as user databases, or is there a configuration issue on the Vinchin side? Any workaround or alternative restore approach would be greatly appreciated.