Skip to main content

How can we help you?

Druva Documentation

SQL errors

This topic lists the SQL errors that you may encounter while working with Druva Phoenix. 

SQL1

Error Message: The SQL agent encountered an internal error 

Error Solution: Contact Druva Support.

SQL3

Error Message: Metadata mismatched from the last backup.  The SQL Server instance was probably not backed up in the previous backup cycle.

Error Description: This error can occur if the metadata of the database selected for backup does not match with the database metadata when it was backed up earlier. 

Error Solution: Run a full backup through the Phoenix Management Console.

SQL4

Error Message: Specified instance not found on present application server.:[Attempting to restore to instance <logical path of instance> not found in server]

Error Description: This error can occur if the specified instance is not present on the target machine.

Error Solution:  To resolve the error:

  • Restore the database file to an alternate location. These files can be used to restore databases by attaching it to the other SQL instance.
  • Ensure that the instance is running on the target machine.

SQL5

Error Message:  Failed to get the SQL product version

Error Description:  This error can occur because of one of the following reasons:

  • sqlcmd is not configured.
  • There is an error with sqlcmd.

Error Solution:   To resolve this error:

  • On the command prompt, type "sqlcmd" to check if sqlcmd is configured.
  • Retry the operation.

Note: This error is applicable for SQL agent versions 4.6.5 and earlier. 

SQL6

Error Message:  Druva Phoenix SQL agent found no instance/database on the server to backup or the SQL service is not running or the backup policy is set to exclude all the databases.

Error Description:  This error can occur because of one of the following reasons:

  • Log chain is broken for selected databases.
  • All databases in simple recovery mode for log backup.
  • All databases excluded from UI.

Error Solution:   To resolve this error:

  • Ensure at least one instance is online and in the working state.
  • Check backup policy and the excluded folder entries.
  • Trigger a full/differential backup.
  • Disable third-party backup tool.
  • At least one database should have FULL recovery mode.
  • Update excluded databases list.

SQL7

Error Message:  Phoenix agent encountered ODBC driver error

Error Description:   This error can occur because of one of the following reasons:

  • Connection with SQL server lost.
  • Meta information for database not available.
  • Not enough permission to access SQL server.

Error Solution:   To resolve this error:

  • Check if SQL server instance is up and running.
  • Permissions for local system account enabled as per documentation.

SQL8

Error Message:  Phoenix agent encountered VIDLIB application error

Error Description: This error can occur because of one of the following reasons:

  • Local network connection disabled
  • Unable to create virtual connection with SQL server
  • Not enough permissions to access SQL server
  • The point-in-time or transaction mark restore of the database fails when log chain for database breaks due to changed/replaced data files.

Error Solution:  This error can be resolved in the following ways:

  • It can be a transient issue and might be auto-resolved in the next log backup cycle.
  • Check the permissions for local system account enabled as per documentation.

SQL9

Error Message:  SQL Agent internal error occurred

Error Solution:   Contact Druva Support.

SQL10

Error Message:  Marked transaction timestamp not found. Insufficient transaction logs to restore marked transaction.

Error Description:  This error can occur due to:

  • Broken transaction log chain
  • Timestamp issues

Error Solution: Contact Druva Support.

SQL11

Error Message:  Invalid time-stamp for point-in-time restore

Error Description:  This error can occur due to:

  • Broken transaction log chain
  • Timestamp issues

Error Solution:   Contact Druva Support.

SQL12

Error Message:  Database is not compatible on a for target SQL server. Please check version compatibility level. 

Error Description:   This error can occur because the SQL Server restore instance is incompatible.

Error Solution:  To resolve this issue, try to restore your database on a compatible SQL server instance. See ALTER DATABASE Compatibility level

Note: This issue is not applicable on SQL server agent 4.6.5 and earlier. 

SQL15

Error Message: SQL agent encountered an internal error

Error Solution: Contact Druva Support.

SQL16

Error Message: SQL Server backup node not healthy.

Error Description: This error occurs when the availability group node is not connected or not in the healthy state.

Error Solution: To resolve this issue, check the status of the cluster and availability group and identify whether there are nodes available based on the backup preference.

SQL17

Error Message: SQL server discovery on the client failed

Error Description: This error occurs when Druva Phoenix does not discover MS-SQL resources, such as instances and AGs.

Error Solution: To resolve this issue, check the Druva Phoenix client log file for errors. Contact Druva Support.

SQL18

Error Message: Different client versions for AG nodes.

Error Description: This error occurs when the different Druva Phoenix client versions are installed on the availability group nodes.

Error Solution: To resolve this issue, ensure that you install the same version of the Phoenix agent on all the availability group nodes.

SQL20

Error Message: Failed to trigger backup request due to unavailability of SQL node.

Error Description: This error occurs due to a failure of the Phoenix agent to trigger backup request caused by unavailability of a SQL node. Check the connection status of the SQL node.

Error Solution: To resolve this issue, check the status of the cluster and availability group and identify whether there are nodes available based on the backup preference.

SQL21

Error Message: Incorrect CLI parameter for schedule passed for triggering the backup job

Error Description: This error can occur if no backup schedule is found for a CLI-triggered backup job.

Error Solution: Cross-check the backup policy schedule parameter while triggering the SQL backup through CLI.

SQL22

Error Message: Incorrect CLI parameter for SQL resource passed for triggering the backup job

Error Description: This error can occur if you provide an invalid name for an instance or availability group for a CLI-triggered backup job.

Error Solution: Cross-check the resource parameter while triggering the SQL backup through CLI.

 

SQL23

Error Message: Incorrect CLI parameter for backup set or policy passed for triggering the backup job

Error Description: This error can occur for a CLI-triggered backup job, because of the following reasons:

  • A backup set is not configured
  • A backup set is disabled
  • A backup type is not configured in the backup set.

Error Solution: Cross-check the backup set parameter while triggering the SQL backup through CLI.

SQL24

Error Message: Backup job can't be triggered because 2 or more backup jobs are running. 

Error Description: This error can occur, if two or more CLI-triggered backup jobs are already running.

Error Solution:  To resolve this issue, wait until there are less than two CLI-triggered backup jobs running.

SQL25

Error Message: Triggered backup job for log backup is not created. 

Error Description: This error can occur if no full backup exists, or another full or differential backup is ongoing for the CLI-triggered backup job.

Error Solution:  To resolve this issue, ensure that you perform a full backup and then retry when no full or differential backup is ongoing.

SQL32

Error Message: No new backup job can be created until the first full backup is completed.   

Error Description: This error can occur if backup jobs are triggered from the command line before the first, full backup completes.

Error Solution:  To resolve this issue, ensure that you wait until the first, full backup completes.

SQL33

Error Message: Database not found during upload.

Error Description: This error can occur if the database on an instance is deleted during backup.

Error Solution: To resolve this issue, ensure that the database on the instance is not deleted during the backup operation.

SQL34

Error Message: Failed to get product version info for instance [instance_name]

Error Description: This error occurs when the Phoenix agent cannot identify the SQL Server version.  One of the reasons why the Phoenix agent cannot identify the SQL Server version is if TLS 1.0/1.1 is disabled.

Error Solution: If TLS 1.0/1.1 is disabled, install the SQL Server Native Client driver 11.0. You can download the SQL Server Native Client driver for the MS-SQL Server 2012 from the Microsoft Download Center. If the problem persists, contact Druva support.

SQL35

Error Message: Database state error. 

Error Description: This error can occur for the replace original database restore job if:

  • The database does not exist on the selected SQL Server instance
  • The database selected for replacement is running on a SQL Server instance that is a part of an Availability Group
  • The selected SQL Server instance is in No recovery mode

Error Solution: To resolve this issue, ensure that:

  • The database exists on the selected SQL Server instance
  • The SQL Server instance is not a part of an Availability Group
  • The SQL Server instance is not in the No-Recovery mode

SQL36 

Error Message: Failed to detach database.

Error Description: This error can occur if Druva Phoenix cannot detach the database from its SQL Server instance during restore.

Error Solution: To resolve this issue, check:

  • If the database exists on the SQL Server instance
  • If any issue on the SQL Server instance is stopping the database from getting detached

SQL37 

Error Message: Current log backup job expired, new log backup job is queued.

Error Description: This error can occur if Druva Phoenix schedules a new SQL log backup job when an existing log backup job is already queued. Druva Phoenix queues only one SQL log backup job at a time. Therefore, when Druva Phoenix triggers a new log backup job, the job gets queued and the earlier log backup job in the queued state is marked as "Backup window expired". This behavior avoids multiple log backup jobs getting accumulated in the queued state, which can occur when a log backup job runs for a long time.

SQL38 

Error message: Phoenix client has not been activated on this device.

Error description: This error occurs when the Druva Phoenix agent (client) needs to be activated on the selected SQL Resource. 
For a SQL Server instance, the client needs to be activated on the selected instance, whereas for an Availability Group (AG), the client needs to be activated on all the nodes of the Availability Group.

Error solution:
Ensure that you install and activate the Phoenix agent on the selected SQL Server and Availability Nodes. If already activated, then restart the Phoenix client service.

SQL40

Error message: Failing job operation, because Sysadmin privileges are not assigned for the user.

Error Description:  Druva Phoenix interfaces with Microsoft Virtual Device Interface (VDI) to back up and restore SQL Database Transaction Logs and SQL VDI differential backups. The user account assigned to the SQL server needs to have the sysadmin role.

Error Solution:  Assign credentials to the SQL server, and ensure that the assigned user account has the sysadmin role. For more information, see Manage credentials for MS-SQL servers and Join a role.

SQL50

Error message: Failed to detach database(s) from instance. 

Error Description:  You may run into this error while choosing to Restore database files from a restore point that has a VDI differential snapshot. While restoring from a VDI snapshot, the Phoenix agent creates a temporary user database and restores .mdf.ndf, and .ldf files over this database. The agent then restores .bak file data over the database and detaches the temporary database. At this point, the database detach may fail if the Phoenix agent does have the privileges to detach a database.

Error Solution:  Use the SQL Management Studio, and perform the following tasks:

  1. Right-click the user database <rst_databasename> referenced in the error, navigate to Tasks, and then click Detach
  2. In the Detach Database dialog box, select Drop Connections and Update Statistics.
  3. Click Detach.

When you detach all the restored databases manually, the databases are deleted automatically. The database files are available at the specified restore destination. 

SQL51

Error message: Restore Failed as database files already present in given download location. Please delete or move the files from downloaded location and trigger the restore again.

Error description: 

You may run into this error while restoring a database to the original SQL Server instance and choosing to replace the original database. This error can occur if the original location has database files associated with a working database on the SQL Server instance.

Error solution: Determine the location of the preexisting database files from Job Progress Logs in the UI or the client job logs, and either delete the files or move them to another location. Trigger the restore again.

SQL52

Error message: Failing job operation, because the CREATE ANY DATABASE permission is not assigned for the user.

Error description: 

Druva Phoenix interfaces with Microsoft Volume Shadow Copy service (VSS) to take snapshot based backups and restores. The user account assigned to the SQL server needs to have the CREATE ANY DATABASE permission.

Error solution: Assign credentials to the SQL server. Ensure that the assigned user account has the dbcreator/sysadmin role. This can also be done by adding CREATE ANY DATABASE in the SQL Server user permissions for the current login. For more information, see Manage credentials for MS-SQL servers and Join a role.

SQL53 

Error message: Transaction log backups will fail as all databases are in Simple recovery model.

Error description: This error occurs when all the databases of a backup set are in the Simple recovery model. SQL Server databases configured with Simple recovery model do not support log backups to keep the space requirements small. Therefore, the transaction log backups for this backup set will fail.

Error solution:
Before creating or editing a backup set, ensure that at least one of the selected databases is configured with the Full recovery model. 
Alternatively, you can remove the Transaction Log schedule from the selected backup policy or select another backup policy without a Transaction Log Backup Schedule.
For more information on modifying the Recovery Model of SQL-Server Databases, see
https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/view-or-change-the-recovery-model-of-a-database-sql-server?view=sql-server-ver15.

SQL54

Error Message: Restore job failed as the Tail-Log backup is not successful.
Error Description: The Tail-Log restore job failed as you selected the Abort restore if tail-log backup fails option while triggering the Tail-Log restore job.
Error Solution: Check the Tail-Log backup job error. If you still want to continue with the Tail-Log Restore, then deselect the Abort restore if tail-log backup fails option and then trigger the Tail-Log restore job.

SQL56

Error Message: Unable to perform download/restore on the restore location due to permission issue. Provide administrator permission for the specified folder/drive.
Error Description

  • In order to download and restore the database files, the Druva Phoenix service needs to have open, create, read, and write permissions on the given restore location. 
  • If the restore directory does not have these permissions to all the Windows users on that machine, then the non-administrator users cannot access the restore directory.
  • This error occurs when the user through which the Phoenix agent runs does not have access to the restore directory.

Error Solution: If the Druva Phoenix service is running on a Standard Windows user, you can assign create, read, write, and open privileges to ‘Everyone’ for the particular restore directory. Otherwise, make sure that the Druva Phoenix service is running on a Windows user that already has the administrator privileges.

SQL57

Error Message: Restore will fail as VSS Writer or SQLWriter Service is not running on the target device.

Error Description: This error can occur if the VSS service is not running or the SQL Writer is not in a stable state.

Error Solution:

Check the VSS service. If the VSS service is not running, manually start the service and switch it to automatic mode. If VSS service is disabled, then switch it to automatic mode.

To know if the VSS SQL writer is in running and have a stable state, type the following on the command-prompt:
vssadmin List Writers

The SQL writer on the Windows services must be running and enabled. It must also be set to automatic.

If both the VSS service and SQLWriter are running, you can restart these services

 

  • Was this article helpful?