Restore operation fails
Issue
The restore operation fails with the following error:
*** Could not deploy package.
Warning SQL72035: [dbo].[auto_tbl_no_keys_bwola] is under change data capture control, but those settings will not be transferred
Warning SQL72035: [dbo].[auto_tbl_with_keys_atumq] is under change data capture control, but those settings will not be transferred
Error SQL72014: Core Microsoft SqlClient Data Provider: Msg 5133, Level 16, State 1, Line 1 Directory lookup for the file "F:\data\db ' wi_t _ h _ _b , _k\tk /db \ a / n_d_6_tmLbcd_1753007294382_0__Primary.mdf" failed with the operating system error 3(The system cannot find the path specified.).
Error SQL72045: Script execution error. The executed script:
CREATE DATABASE [$(DatabaseName)]
ON
PRIMARY(NAME = [$(DatabaseName)], FILENAME = N'$(DefaultDataPath)$(DefaultFilePrefix)_Primary.mdf')
LOG ON (NAME = [$(DatabaseName)_log], FILENAME = N'$(DefaultLogPath)$(DefaultFilePrefix)_Primary.ldf') COLLATE SQL_Latin1_General_CP1_CI_AS;
Error SQL72014: Core Microsoft SqlClient Data Provider: Msg 1802, Level 16, State 1, Line 1 CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
Error SQL72045: Script execution error. The executed script:
CREATE DATABASE [$(DatabaseName)]
ON
PRIMARY(NAME = [$(DatabaseName)], FILENAME = N'$(DefaultDataPath)$(DefaultFilePrefix)_Primary.mdf')
LOG ON (NAME = [$(DatabaseName)_log], FILENAME = N'$(DefaultLogPath)$(DefaultFilePrefix)_Primary.ldf') COLLATE SQL_Latin1_General_CP1_CI_AS;
Cause
This error occurs if the restored database name has special characters.
โResolution
Retry restoring the database without providing special characters in the restored database name.
Restore job remains stuck
Issue
The restore job gets stuck.
Cause
The restore job may get stuck due to multiple reasons. One reason could be that the Druva Quantum Bridge was stopped while the restore job was in progress, causing the restore job to remain stuck.
Resolution
Retrigger the restore job after some time.