✎ [V7] ISSUE: Skip backing up database (Database does not exist) (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 (Database does not exist) (MS SQL database backup) =====
This article only applies to Ahsay software version 7 
<html>
<br>
<br>
 <b>
  Article ID:
 </b>
 5306
 <br/>
 <b>
  Reviewed:
 </b>
 2018-02-22
 <br/>
 <br/>
 <b>
  Product Version:
 </b>
 <br/>
 AhsayOBM: 7.3.0.0  to 7.x
 <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, 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">
     <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_instance (SQL_version)\db_name" (Database does not exist)</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>
</html>

===== Cause =====
The message suggests that the corresponding database does not exist on the SQL server anymore.


===== Resolution =====
<html>
To resolve the issue, deselect the corresponding database from the <b>Source</b> setting of affected backup set.
<br>
<br>
<img style="width:65%" src="http://wiki.ahsay.com/lib/exe/fetch.php?media=public:SQL_deleted_db.png">
<br>
<br>
If the SQL instance instead of individual database was selected as backup source, create a <b>Deselected Source</b> path on the AhsayCBS web console instead.
<br>
<font size=2>
<ol>
<li><font color=black>Login to the AhsayCBS web console.</font></li>
<li><font color=black>Select <b>Users, Groups & Policies</b>, then the corresponding backup user.</font></li>
<li><font color=black>Select <b>Backup Set</b>, then the affected backup set.</font></li>
<li><font color=black>Select <b>Source</b>, then click on the <b>Create</b> button under <b>Deselected Source</b></font></li><br>
<li><font color=black>Enter the path of the corresponding database.
<br>
<br>
Note: 
<br>
Format of the deselected source path (the SQL instance name and database name must be <a href="https://www.w3schools.com/tags/ref_urlencode.asp">URL encoded</a>):
<br>
<br>
<i>${sql_instance_name}\${db_name}</i>
<br>
<br>
For example, for warning:
<br>
<br>
<font color=#0040FF>Skip backing up "W2k12R2-MSSQL2K\MSDB (SQL SERVER 12.0.5000)\DeletedDB" (Database does not exist)</font>
<br>
<br>
The path is:
<br>
<br>W2k12R2<font color=red>%2d</font>MSSQL2K<font color=red>%5c</font>MSDB\DeletedDB
<br>
<br>
Where the hyphen (-) and backslash (\) character in the instance name were replaced by <font color=red>%2d</font> and <font color=red>%5c</font> respectively.</font></li><br>
<li><font color=black>Click <b>Add</b>, then repeat the same steps for all deleted databases.</font></li>
</ol>
</font>
If you want to delete the backup data of the correpsonding database from the backup destination.
<br>
<br>
<ol>
<font size=2>
<li><font color=black>Login to AhsayOBM.</font></li>
<li><font color=black>Select <b>Utilities</b>, then <b>Delete Backup Data</b>.</font></li>
<li><font color=black>Select the affected backup set, the backup destination, and <b>Choose from ALL files</b>.
<br>
<br>
<img style="width:65%" src="http://wiki.ahsay.com/lib/exe/fetch.php?media=public:SQL_deleted_db_2.png">
</font></li><br>
<li><font color=black>Select the corresponding database, then <b>Delete</b>.</font></li>
</font>
</ol>

</html>
===== Keywords =====
skip, skipping, skipped, db, deleted, removed, temp, mssql
User Tools

Site Tools

Page Tools
