-
Title
Unable to backup database using virtual SQL client - Error “The system cannot find the file specified” -
Description
Unable to backup database using virtual SQL client.
Backup job fails with “The system cannot find the file specified”.
As displayed in binary log extract below.
Binary log extract:
Job Message 2018/10/14 07:23:33 576 Data Plugin V-QSLserver Backing up database 'model' - backup type 'DATABASE DIFFERENTIAL'
Error 2018/10/14 07:23:33 576 Data Plugin V-QSLserver ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device 'NVBU_6352'. Operating system error 0x80070002(The system cannot find the file specified.).
Error 2018/10/14 07:23:34 576 Data Plugin V-QSLserver ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.
Error 2018/10/14 07:23:48 576 Data Plugin V-QSLserver SQL command failed before VD transfer
Error 2018/10/14 07:23:48 576 Data Plugin V-QSLserver The VDI backup operation failed.
Error 2018/10/14 07:23:48 576 Data Plugin V-QSLserver Backup failed due to error in database 'model'
Warning 2018/10/14 07:23:48 576 Data Plugin V-QSLserver Failed to backup SQL Server database: model
-
Cause
Cluster IP address used and not listener IP address as recommended when configuring AlwaysOn Availability Group or Failover Clustering of SQL Server
-
Resolution
Recreate virtual client for AlwaysOn Availability Group or Failover Clustering of SQL Servers using listener IP address.
See documentation on https://support.quest.com/technical-documents/netvault-backup-plug-in-for-sql-server/11.4.5/user-guide/3#TOPIC-837725
Extract from documentation:
• When configuring AlwaysOn Availability Group or Failover Clustering of SQL Server, in the configuration of the Virtual Client, use the configured listener IP of the SQL Server instead of IP address of the cluster.