User Tools

Site Tools



Ahsay Backup Software

Backup Set Types

Supported Storage

Features in OBM / ACB

Features in CBS

Brand and Customize



Performance Testing

FAQs and Known Issues

Can't Find What You Need?


ISSUE: Skip backing up database (Instance is offline) for database that is actually online (MS SQL database backup)

Article ID: 5317
Reviewed: 13/03/2018

Product Version:
AhsayOBM: Post-
OS: Windows

Problem Description

When performing a MS SQL database backup (ODBC backup mode), the following warning message is received in the backup report:

No. Type Timestamp Log
* ... ... ...
* info ... Reading backup source from hard disk...
* warn YYYY/MM/DD hh:mm:ss Skip backing up "SQL_hostname\MSDB\db_name (SQL SERVER version)"
(Instance is offline)
* ... ... ...
The affected database instance is actually online in SQL Server Management Studio (SSMS).


This issue can occur for SQL server with case-sensitive collation.

This issue can also occur if the Windows user configured for the backup set does not have permission to access the corresponding database.


To resolve the issue, patch the AhsayOBM application to version or above.  The instructions can be found by Clicking Here.

Also, confirm if the Windows user configured for the backup set have sufficient permission to access the corresponding database:

If the problem persist, modify the Log-on setting of the AhsayOBM scheduler service:

  1. Under Control Panel, open Administrative Tools then Services.
  2. Right click on Ahsay Online Backup Manager Services, select the Log on tab.
  3. Select the This Account option.
  4. Enter the login credentials of an account with sufficient permission.
  5. Restart the service afterward.


sql, odbc, offline, online, mssql, instance, off-line, off

public/5317_skip_backing_up_db_instance_offline_for_online_db.txt · Last modified: 2018/08/07 17:20 by edward.chan