✎ [V7] ISSUE: Skip backing up database (Instance is offline) for database that is actually online (MS SQL database backup) [Ahsay Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
===== [V7] ISSUE: Skip backing up database (Instance is offline) for database that is actually online (MS SQL database backup) =====

<html>
 <b>
  Article ID:
 </b>
 5317
 <br/>
 <b>
  Reviewed:
 </b>
 2018-03-13
 <br/>
 <br/>
 <b>
  Product Version:
 </b>
 <br/>
 AhsayOBM: Post-7.3.0.0 
 <br/>
 OS: Windows
</html>

<html>
<FONT COLOR=red SIZE=+1>
<B>ATTENTION</B>
1st January, 2022: v7 officially End-of-Life [<A HREF=https://wiki.ahsay.com/doku.php?id=public:announcement:ahsay_v7_eol>details</A>]
</FONT>
</html>
===== Problem Description =====
<html>
When performing a MS SQL database backup (ODBC backup mode), the following warning message is received in the backup report:
 <br>
 <table border="0" cellpadding="0" cellspacing="0" width="850">
  <tr>
   <td bgcolor="#E8E8E8" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-TOP: #C0C0C0  1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle">
    No.
   </td>
   <td bgcolor="#E8E8E8" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-TOP: #C0C0C0  1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle">
    Type
   </td>
   <td bgcolor="#E8E8E8" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-TOP: #C0C0C0  1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle">
    Timestamp
   </td>
   <td bgcolor="#E8E8E8" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-TOP: #C0C0C0 1px solid; BORDER-RIGHT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle">
    Log
   </td>
  </tr>
  <tr>
   <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top">
    *
   </td>
   <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top">
    ...
   </td>
   <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top">
    ...
   </td>
   <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-RIGHT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle">
    ...
   </td>
  </tr>
  <tr>
   <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top">
    *
   </td>
   <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top">
     info
   </td>
   <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top">
     ...
   </td>
   <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-RIGHT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle">
   Reading backup source from hard disk...
   </td>
  </tr>  
  <tr>
   <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top">
    *
   </td>
   <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top">
     <font color=#0040FF>warn</font>
   </td>
   <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top">
     <font color=#0040FF>YYYY/MM/DD
     hh:mm:ss</font>
   </td>
   <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-RIGHT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle">
   <font color=#0040FF>Skip backing up "SQL_hostname\MSDB\db_name (SQL SERVER version)" 
   <br>
   (Instance is offline)</font>
   </td>
  </tr>
  <tr>
   <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top">
    *
   </td>
   <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top">
    ...
   </td>
   <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top">
    ...
   </td>
   <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-RIGHT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle">
    ...
   </td>
  </tr>
 </table>
Note: 
<br>
The affected database instance is actually online in SQL Server Management Studio (SSMS).
</html>


===== Cause =====
<html>
This issue can occur for SQL server with <a href="https://docs.microsoft.com/en-us/sql/t-sql/statements/sql-server-collation-name-transact-sql">case-sensitive collation</a>.
<br>
<br>
This issue can also occur if the Windows user configured for the backup set does not have permission to access the corresponding database.
</html>


===== Resolution =====
<html>
To resolve the issue, patch the AhsayOBM application to version 7.15.2.2 or above. &nbsp;The instructions can be found by 
<a href="http://wiki.ahsay.com/doku.php?id=public:5146_faq:how_to_install_the_latest_patch_set_for_ahsayobm_ahsayacb">Clicking Here</a>.
<br>
<br>
Also, confirm if the Windows user configured for the backup set have sufficient permission to access the corresponding database:
<br>
<br>
<img style="width:75%" src="http://wiki.ahsay.com/lib/exe/fetch.php?media=public:SQL_win_account.PNG"/>
<br>
<br>
If the problem persist, modify the Log-on setting of the AhsayOBM scheduler service:
<br>
<ol>
  <li>
   <font color=black>Under <b>Control Panel</b>, open <b>Administrative Tools</b> then <b>Services</b>.</font>
  </li>
  <li>
   <font color=black>Right click on <b>Ahsay Online Backup Manager Services</b>, select the <b>Log on</b> tab.</font>
  </li>
  <li>
   <font color=black>Select the <b>This Account</b> option.</font>
  </li>
  <li>
   <font color=black>Enter the login credentials of an account with sufficient permission.</font>
  </li>
  <li>
   <font color=black>Restart the service afterward.</font>
  </li>
 </ol>
</html>


===== Keywords =====
sql, odbc, offline, online, mssql, instance, off-line, off
User Tools

Site Tools

Page Tools
