✎ [V8] ISSUE: [VSSDatabaseExpt] VSS_E_UNEXPECTED_PROVIDER_ERROR (MS SQL database backup in VSS mode) [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.
===== [V8] ISSUE: [VSSDatabaseExpt] VSS_E_UNEXPECTED_PROVIDER_ERROR (MS SQL database backup in VSS mode) =====


<html>
 <b>
  Article ID:
 </b>
 8072
 <br/>
 <b>
  Reviewed:
 </b>
 \2020-04-09
 <br/>
 <br/>
 <b>
  Product Version:
 </b>
 <br/>
 AhsayOBM: 8.1.0.0 to 8.x
 <br/>
 OS: Windows
</html>


===== Problem Description =====
<html>
When performing either a scheduled or manual MS SQL Server database backup job in VSS backup mode. The following backup error are 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">
    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">
    Using Temporary Directory ...
   </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=#FF0000>
     erro
    </font>
   </td>
   <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top">
    <font color=#FF0000>
     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=#FF0000> Cannot start shadow copy, reason =VSS_E_UNEXPECTED_PROVIDER_ERROR
    </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>  

<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=#FF0000>	
    erro
    <font>
   </td>
   <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top">
    <font color=#FF0000>
     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=#FF0000>
    [VSSDatabaseExpt] VSS_E_UNEXPECTED_PROVIDER_ERROR
    </font>	   
   </td>
  </tr>
 </table>

<font color=black> The backup error persists even after the following actions have been performed. <font>
<br></br>
<ol>
 <li><font color=black> 
  The MS SQL Server version is updated to the latest service pack / rollup</font>
 </li>
 <li><font color=black> 
  The MS SQL Server Server has been rebooted
  </font>
 <li><font color=black> 
  The VSS writers has been re-registered using the %OBM_Install_home%\bin\RegisterVSS.bat</font>
 </li>
</ol>
Checking the status of the VSS writers using the vssadmin list writers command shows the 'SqlServerWriter' is still in a "Failed" state.
<br>
<br>

Example:
<br>
<br>
    <table border="0" cellpadding="0" cellspacing="0" width="850">
    <tr>
     <td style="BACKGROUND-COLOR: black">
      <font size=2 color=white><p style="font-family:courier;"> 
	  	  
C:\WINDOWS\system32>vssadmin list writers<br>
vssadmin 1.1 - Volume Shadow Copy Service administrative command-line tool<br>
(C) Copyright 2001-2013 Microsoft Corp.<br>
<br>
Writer name: 'System Writer'<br>
&nbsp;&nbsp;&nbsp;&nbsp;Writer Id: {e8132975-6f93-4464-a53e-1050253ae220}<br>
&nbsp;&nbsp;&nbsp;&nbsp;Writer Instance Id: {a2f2507d-b348-493a-9685-da3f20959e9d}<br>
&nbsp;&nbsp;&nbsp;&nbsp;State: [1] Stable<br>
&nbsp;&nbsp;&nbsp;&nbsp;Last error: No error<br>

...
<br>
<br>
Writer name:'SqlServerWriter'<br>
&nbsp;&nbsp;&nbsp;&nbsp;Writer Id: {a65faa63-5ea8-4ebc-9dbd-a0c4db26912a}<br>
&nbsp;&nbsp;&nbsp;&nbsp;Writer Instance Id: {3de4f842-4d57-4198-9949-3b3f8c2629dc}<br>
&nbsp;&nbsp;&nbsp;&nbsp;State: [7] Failed<br>
&nbsp;&nbsp;&nbsp;&nbsp;Last error: No error<br>
<br>
<br>
Writer name: 'FRS Writer'<br>
&nbsp;&nbsp;&nbsp;&nbsp;Writer Id: {d76f5a28-3092-4589-ba48-2958fb88ce29}<br>
&nbsp;&nbsp;&nbsp;&nbsp;Writer Instance Id: {d35e3901-f9b9-4fa6-86af-36b8a4872933}<br>
&nbsp;&nbsp;&nbsp;&nbsp;State: [1] Stable<br>
&nbsp;&nbsp;&nbsp;&nbsp;Last error: No error<br>
...

     </td>
    </tr>
   </table> 
</html>  


===== Cause =====
<html>
This issue can occur if there is not enough space on the SQL server to create a VSS snapshot of the database. In other words, the maximum size of the shadow storage area is too small.</html>


===== Resolution =====
<html>
<font color=black> To resolve this issue, consider to resize the maximum shadow storage area on the MS SQL server.<font> 
<br><br>

Refer to the following Microsoft Document for details on how to resize the shadow storage area:
<br><br>
<a href="https://docs.microsoft.com/en-us/windows-server/administration/windows-commands/vssadmin-resize-shadowstorage">https://docs.microsoft.com/en-us/windows-server/administration/windows-commands/vssadmin-resize-shadowstorage</a>
</html>

===== Keywords =====
UNEXPECTED, PROVIDER_ERROR, VSSDatabaseExpt, shadow storage, resize, VSS Writer, SqlServerWriter
User Tools

Site Tools

Page Tools
