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:5317_skip_backing_up_db_instance_offline_for_online_db

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-7.3.0.0
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)
* ... ... ...
Note:
The affected database instance is actually online in SQL Server Management Studio (SSMS).

Cause

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.

Resolution

To resolve the issue, patch the AhsayOBM application to version 7.15.2.2 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.

Keywords

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