Skip to main content

Troubleshooting Azure SQL restore issues

Updated yesterday

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.

Did this answer your question?