User Tools

Site Tools

You are here: Ahsay Wiki » Welcome to AhsayWiki » 8081_cannot_start_shadow_copy_reason_listsqlsvr.sqldriverconnectw_failed
public:8081_cannot_start_shadow_copy_reason_listsqlsvr.sqldriverconnectw_failed

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
public:8081_cannot_start_shadow_copy_reason_listsqlsvr.sqldriverconnectw_failed [2020/05/26 09:12]
yuk.cheng removed 		— (current)
Line 1: Line 1:
-=====  ISSUE: Cannot start shadow copy, reason =[ListSQLsvr.SQLDriverConnectW]failed (MS SQL Server Database Backup) ​  ===== 
  
-<​html>​ 
- <​b>​ 
-  Article ID: 
- </​b>​ 
-8081 
- <​br/>​ 
- <​b>​ 
-  Reviewed: 
- </​b>​ 
- ​25/​05/​2020 
- <​br/>​ 
- <​br/>​ 
- <​b>​ 
-  Product Version: 
- </​b>​ 
- <​br/>​ 
- ​AhsayCBS:​ 7.5.0.0 or above 
- <​br/>​ 
- OS: Windows 
- <​br/>​ 
- <​br/>​ 
-</​html>​ 
-===== Problem Description ===== 
-<​html>​ 
-When performing either a scheduled or manual MS SQL database backup job. The following backup error 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">​ 
-    [Start] backing up database... 
-   </​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 =[ListSQLsvr.SQLDriverConnectW]failed 
-    </​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">​ 
-     <​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>​ 
-    [SQLServerExpt$SQLDriverConnectFailedExpt][ListSQLsvr.SQLDriverConnectW]failed 
- </​font>​ 
-   </​td>​ 
-  </tr> 
- </​table>​ 
-</​html>​ 
- 
- 
-===== Cause ===== 
-<​html>​ 
-The error is returned by the MS SQL Writer after it has encountered a Volume Shadow Copy limitation, when creating a VSS snapshot of one or more databases which are located on a network drive. 
-</​html>​ 
- 
- 
-===== Resolution ===== 
-<​html>​ 
-To resolve this issue, either: 
-<ol> 
- <​li><​font color=black> ​ 
-  Unselect the affected databases located on the network drive from the backup set.</​font>​ 
- </​li>​ 
-<br> 
- <​li><​font color=black> ​ 
- ​Create a new backup set using ODBC backup mode which supports backup of databases located on a network drive.</​font>​ 
- </​li>​ 
-</ol> 
- ​Please refer to the requirements section in our Microsoft SQL Server Database Backup & Restore Guide for more details: 
- <​br/>​ 
- <a class="​postlink"​ href="​https://​www.ahsay.com/​download/​download_document_v8_obm-user-guide-sql.jsp">​ 
-  https://​www.ahsay.com/​download/​download_document_v8_obm-user-guide-sql.jsp</​a>​ 
-</​html>​ 
- 
- 
-===== Keywords ===== 
-VSS mode, ODBC mode, MS SQL Writer, network drive, Volume Shadow Copy 

Page Tools