===== [V7] ISSUE: Skip backing up database (Database does not exist) (MS SQL database backup) ===== This article only applies to Ahsay software version 7

Article ID: 5306
Reviewed: 2018-02-22

Product Version:
AhsayOBM: 7.3.0.0 to 7.x
OS: Windows ATTENTION 1st January, 2022: v7 officially End-of-Life [details] ===== Problem Description ===== When performing a MS SQL database backup, the following warning message is received in the backup report:
No. Type Timestamp Log
* ... ... ...
* warn YYYY/MM/DD hh:mm:ss Skip backing up "SQL_instance (SQL_version)\db_name" (Database does not exist)
* ... ... ...
===== Cause ===== The message suggests that the corresponding database does not exist on the SQL server anymore. ===== Resolution ===== To resolve the issue, deselect the corresponding database from the Source setting of affected backup set.



If the SQL instance instead of individual database was selected as backup source, create a Deselected Source path on the AhsayCBS web console instead.
  1. Login to the AhsayCBS web console.
  2. Select Users, Groups & Policies, then the corresponding backup user.
  3. Select Backup Set, then the affected backup set.
  4. Select Source, then click on the Create button under Deselected Source

  5. Enter the path of the corresponding database.

    Note:
    Format of the deselected source path (the SQL instance name and database name must be URL encoded):

    ${sql_instance_name}\${db_name}

    For example, for warning:

    Skip backing up "W2k12R2-MSSQL2K\MSDB (SQL SERVER 12.0.5000)\DeletedDB" (Database does not exist)

    The path is:

    W2k12R2%2dMSSQL2K%5cMSDB\DeletedDB

    Where the hyphen (-) and backslash (\) character in the instance name were replaced by %2d and %5c respectively.

  6. Click Add, then repeat the same steps for all deleted databases.
If you want to delete the backup data of the correpsonding database from the backup destination.

  1. Login to AhsayOBM.
  2. Select Utilities, then Delete Backup Data.
  3. Select the affected backup set, the backup destination, and Choose from ALL files.


  4. Select the corresponding database, then Delete.
===== Keywords ===== skip, skipping, skipped, db, deleted, removed, temp, mssql