MSSQL restore problem

Hello, I have a problem with restoring MSSQL backup.

Service is dying and urbackup logging error.

image

Restore log:
02.12.2019 15:47:31: Starting restore operation... 02.12.2019 15:47:31: Collecting information about running writers... 02.12.2019 15:47:34: Selecting components to restore... 02.12.2019 15:47:35: Starting restore operation (pre restore)... 02.12.2019 15:47:35: Restoring file set 0 of of component "AdventureWorksLT2017" of writer "SqlServerWriter" to "C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA"... 02.12.2019 15:47:37: Error getting restore status.

DEBUG:
2019-12-02 15:11:33: ERROR: Error while enumerating user "NT AUTHORITY\SYSTEM" groups: 2453 2019-12-02 15:11:48: WARNING: Info not found at 'c:' - reindexing 2019-12-02 15:12:01: ERROR: Error getting account SID of user APPLICATION PACKAGE AUTHORITY\ALL APPLICATION PACKAGES. Code: 1332 - No mapping between account names and security IDs was done. 2019-12-02 15:29:31: ERROR: Error getting account SID of user APPLICATION PACKAGE AUTHORITY\ALL APPLICATION PACKAGES. Code: 1332 - No mapping between account names and security IDs was done. 2019-12-02 15:29:31: ERROR: Fatal exception code 3221225477 at address 0x00007FFA8252B315 2019-12-02 15:29:32: ERROR: Fatal exception (APPLICATION CRASHED). Crash dump written to "C:\WINDOWS\TEMP\UrBackup\v2.0.0-20191202-152931-17912-14412.dmp" 2019-12-02 15:29:32: ERROR: Program abort (SIGABRT) 2019-12-02 15:33:40: ERROR: Error getting account SID of user APPLICATION PACKAGE AUTHORITY\ALL APPLICATION PACKAGES. Code: 1332 - No mapping between account names and security IDs was done. 2019-12-02 15:33:42: ERROR: Error getting account SID of user APPLICATION PACKAGE AUTHORITY\ALL APPLICATION PACKAGES. Code: 1332 - No mapping between account names and security IDs was done. 2019-12-02 15:34:15: ERROR: Error getting account SID of user APPLICATION PACKAGE AUTHORITY\ALL APPLICATION PACKAGES. Code: 1332 - No mapping between account names and security IDs was done. 2019-12-02 15:34:18: ERROR: Error getting account SID of user APPLICATION PACKAGE AUTHORITY\ALL APPLICATION PACKAGES. Code: 1332 - No mapping between account names and security IDs was done. 2019-12-02 15:36:21: ERROR: Error getting account SID of user APPLICATION PACKAGE AUTHORITY\ALL APPLICATION PACKAGES. Code: 1332 - No mapping between account names and security IDs was done. 2019-12-02 15:36:23: ERROR: Error getting account SID of user APPLICATION PACKAGE AUTHORITY\ALL APPLICATION PACKAGES. Code: 1332 - No mapping between account names and security IDs was done. 2019-12-02 15:36:45: ERROR: Error getting account SID of user APPLICATION PACKAGE AUTHORITY\ALL APPLICATION PACKAGES. Code: 1332 - No mapping between account names and security IDs was done. 2019-12-02 15:36:45: ERROR: Cannot find "c:\program files\microsoft sql server\mssql14.mssqlserver\mssql\data\master.mdf" in open file list 2019-12-02 15:36:45: ERROR: Cannot open file "c:\program files\microsoft sql server\mssql14.mssqlserver\mssql\data\master.mdf" for writing. Not restoring file. Code 0 2019-12-02 15:36:46: ERROR: Error getting account SID of user APPLICATION PACKAGE AUTHORITY\ALL APPLICATION PACKAGES. Code: 1332 - No mapping between account names and security IDs was done. 2019-12-02 15:36:46: ERROR: Cannot find "c:\program files\microsoft sql server\mssql14.mssqlserver\mssql\data\mastlog.ldf" in open file list 2019-12-02 15:36:46: ERROR: Cannot open file "c:\program files\microsoft sql server\mssql14.mssqlserver\mssql\data\mastlog.ldf" for writing. Not restoring file. Code 0 2019-12-02 15:36:47: ERROR: Error getting account SID of user APPLICATION PACKAGE AUTHORITY\ALL APPLICATION PACKAGES. Code: 1332 - No mapping between account names and security IDs was done. 2019-12-02 15:36:47: ERROR: Cannot find "c:\program files\microsoft sql server\mssql14.mssqlserver\mssql\data\model.mdf" in open file list 2019-12-02 15:36:47: ERROR: Cannot open file "c:\program files\microsoft sql server\mssql14.mssqlserver\mssql\data\model.mdf" for writing. Not restoring file. Code 0 2019-12-02 15:36:48: ERROR: Error getting account SID of user APPLICATION PACKAGE AUTHORITY\ALL APPLICATION PACKAGES. Code: 1332 - No mapping between account names and security IDs was done. 2019-12-02 15:36:48: ERROR: Cannot find "c:\program files\microsoft sql server\mssql14.mssqlserver\mssql\data\modellog.ldf" in open file list 2019-12-02 15:36:48: ERROR: Cannot open file "c:\program files\microsoft sql server\mssql14.mssqlserver\mssql\data\modellog.ldf" for writing. Not restoring file. Code 0 2019-12-02 15:36:49: ERROR: Error getting account SID of user APPLICATION PACKAGE AUTHORITY\ALL APPLICATION PACKAGES. Code: 1332 - No mapping between account names and security IDs was done. 2019-12-02 15:36:49: ERROR: Cannot find "c:\program files\microsoft sql server\mssql14.mssqlserver\mssql\data\MSDBData.mdf" in open file list 2019-12-02 15:36:49: ERROR: Cannot open file "c:\program files\microsoft sql server\mssql14.mssqlserver\mssql\data\MSDBData.mdf" for writing. Not restoring file. Code 0 2019-12-02 15:36:50: ERROR: Error getting account SID of user APPLICATION PACKAGE AUTHORITY\ALL APPLICATION PACKAGES. Code: 1332 - No mapping between account names and security IDs was done. 2019-12-02 15:36:50: ERROR: Cannot find "c:\program files\microsoft sql server\mssql14.mssqlserver\mssql\data\MSDBLog.ldf" in open file list 2019-12-02 15:36:50: ERROR: Cannot open file "c:\program files\microsoft sql server\mssql14.mssqlserver\mssql\data\MSDBLog.ldf" for writing. Not restoring file. Code 0 2019-12-02 15:36:51: ERROR: Error getting account SID of user APPLICATION PACKAGE AUTHORITY\ALL APPLICATION PACKAGES. Code: 1332 - No mapping between account names and security IDs was done. 2019-12-02 15:36:53: ERROR: Error getting account SID of user APPLICATION PACKAGE AUTHORITY\ALL APPLICATION PACKAGES. Code: 1332 - No mapping between account names and security IDs was done. 2019-12-02 15:36:55: ERROR: Error getting account SID of user APPLICATION PACKAGE AUTHORITY\ALL APPLICATION PACKAGES. Code: 1332 - No mapping between account names and security IDs was done. 2019-12-02 15:36:57: ERROR: Error getting account SID of user APPLICATION PACKAGE AUTHORITY\ALL APPLICATION PACKAGES. Code: 1332 - No mapping between account names and security IDs was done. 2019-12-02 15:37:15: ERROR: Error getting account SID of user APPLICATION PACKAGE AUTHORITY\ALL APPLICATION PACKAGES. Code: 1332 - No mapping between account names and security IDs was done. 2019-12-02 15:37:17: ERROR: Error getting account SID of user APPLICATION PACKAGE AUTHORITY\ALL APPLICATION PACKAGES. Code: 1332 - No mapping between account names and security IDs was done. 2019-12-02 15:41:47: ERROR: Not found 2019-12-02 15:42:06: ERROR: Pipe broken while sending bitmap 2019-12-02 15:42:30: ERROR: Error getting account SID of user APPLICATION PACKAGE AUTHORITY\ALL APPLICATION PACKAGES. Code: 1332 - No mapping between account names and security IDs was done. 2019-12-02 15:43:04: ERROR: Error getting account SID of user APPLICATION PACKAGE AUTHORITY\ALL APPLICATION PACKAGES. Code: 1332 - No mapping between account names and security IDs was done. 2019-12-02 15:43:04: ERROR: Fatal exception code 3221225477 at address 0x00007FFA8216B315 2019-12-02 15:43:04: ERROR: Fatal exception (APPLICATION CRASHED). Crash dump written to "C:\Users\GoGLiKK\AppData\Local\Temp\UrBackup\v2.0.0-20191202-154304-2864-12884.dmp" 2019-12-02 15:43:04: ERROR: Program abort (SIGABRT) 2019-12-02 15:47:26: WARNING: Parent of file with FRN 53480245575223031 (Name "00BE0000000306F75C09039E") with FRN 1688849860263970 not found. Searching via MFT as fallback. 2019-12-02 15:47:26: WARNING: Parent directory not found in MFT. Was probably deleted. 2019-12-02 15:47:26: WARNING: Parent of file with FRN 53480245575223031 (Name "00BE0000000306F75C09039E") with FRN 1688849860263970 not found. Searching via MFT as fallback. 2019-12-02 15:47:26: WARNING: Parent directory not found in MFT. Was probably deleted. 2019-12-02 15:47:35: ERROR: Error getting account SID of user APPLICATION PACKAGE AUTHORITY\ALL APPLICATION PACKAGES. Code: 1332 - No mapping between account names and security IDs was done. 2019-12-02 15:47:35: ERROR: Fatal exception code 3221225477 at address 0x00007FFA8243B315 2019-12-02 15:47:35: ERROR: Fatal exception (APPLICATION CRASHED). Crash dump written to "C:\WINDOWS\TEMP\UrBackup\v2.0.0-20191202-154735-15472-18032.dmp" 2019-12-02 15:47:35: ERROR: Program abort (SIGABRT)

Could you send one of those .dmp files to bugreports@urbackup.org . E.g. "C:\WINDOWS\TEMP\UrBackup\v2.0.0-20191202-154735-15472-18032.dmp"?

I will send it but can i open this dump file?

Open? E.g. with WinDbg https://docs.microsoft.com/en-us/windows-hardware/drivers/debugger/debugger-download-tools

@uroni can i open case on this issue ?

Dear @uroni, do you have any bug tracking or issue management where we can publish problems? I have the same issue with MS SQL Database Restoration Process . Thanks.

Thanks for the dump files.

Found the issue:

Hello @uroni

restore is successful but status bar is not correct.

Hello,
thanks for a bug fix. Can I compile the client with Visual Studio 2019?