User Tools

Site Tools


Sidebar

Announcement

Ahsay Backup Software

Backup Set Types

Supported Storage

Features in OBM / ACB

Features in CBS

Brand and Customize

License

Documentation

Performance Testing

FAQs and Known Issues

Can't Find What You Need?

public:5306_skip_backup_up_db_does_not_exist

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: 22/02/2018

Product Version:
AhsayOBM: 7.3.0.0 or above
OS: Windows

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

public/5306_skip_backup_up_db_does_not_exist.txt · Last modified: 2019/04/23 09:45 by edward.chan