public:8086_issue:vss_e_writererror_nonretryable

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
public:8086_issue:vss_e_writererror_nonretryable [2020/11/10 18:27]
edward.chan
public:8086_issue:vss_e_writererror_nonretryable [2021/12/14 02:27] (current)
anna.olalia
Line 1: Line 1:
-=====  ISSUE: ​The writer operation failed because of an error that might recur if another ​shadow copy is created ​(VSS_E_WRITERERROR_NONRETRYABLE) ​  =====+===== [V8] ISSUE: ​Cannot start shadow copy (VSS_E_WRITERERROR_NONRETRYABLE) (MS SQL server with large number of databases)   =====
  
 <​html>​ <​html>​
Line 10: Line 10:
   Reviewed:   Reviewed:
  </​b>​  </​b>​
- 10/11/2020+ 2020-11-10
  <​br/>​  <​br/>​
  <​br/>​  <​br/>​
Line 17: Line 17:
  </​b>​  </​b>​
  <​br/>​  <​br/>​
- ​AhsayOBM:​ 8.1.0.0 ​or above+ ​AhsayOBM:​ 8.1.0.0 ​to 8.x
  <​br/>​  <​br/>​
  OS: Windows  OS: Windows
Line 114: Line 114:
 ===== Cause ===== ===== Cause =====
 <​html>​ <​html>​
-The error message is returned by MS SQL VSS writer, suggesting that there were insufficient number of worker threads configured on the MS SQL Server to support the backup all databases selected for backup.+The error message is returned by MS SQL VSS writer, suggesting that there was an insufficient number of worker threads configured on the MS SQL Server to support the backup all databases selected for backup.
  <​br/>​  <​br/>​
  <​br/>​  <​br/>​
Line 131: Line 131:
 <​html>​ <​html>​
 To resolve this issue, either: To resolve this issue, either:
- <br/+<br> 
- <br/+ 
- 1. Create additional backup sets (to be performed at different time) for the excess databases. +<ol
- <​br/+<​li><​font color=black>​Create additional backup sets (to be performed at different time) for the excess databases. 
- <​br/+<​br>​ 
- or +<​br>​ 
- <br/> +or 
- <​br/+ 
- 2. Increase the maximum number of worker threads on the MS SQL Server. +</font></​li
- <​br/+<​br>​ 
- <​br/+ 
- To configure the max worker threads option: +<​li><​font color=black>​Increase the maximum number of worker threads on the MS SQL Server. 
- <​br/>+<​br>​ 
 +<​br>​ 
 +To configure the max worker threads option: 
 +<br
 +<br>
  <​ul>​  <​ul>​
   <li>   <li>
-   <​font color=black>​In Object Explorer, right-click a server and select <​b>​Properties</​b>​.</​font>​+   <​font color=black>​In ​the Object Explorer, right click a server and select <​b>​Properties</​b>​.</​font>​
   </li>   </li>
 +  <br>
   <li>   <li>
    <​font color=black>​Click the <​b>​Processors</​b>​ node.</​font>​    <​font color=black>​Click the <​b>​Processors</​b>​ node.</​font>​
   </li>   </li>
 +  <br>
   <li>   <li>
    <​font color=black>​In the <​b>​Max worker threads</​b>​ box, type or select a value for the max worker thread.</​font>​    <​font color=black>​In the <​b>​Max worker threads</​b>​ box, type or select a value for the max worker thread.</​font>​
   </li>   </li>
  </​ul>​  </​ul>​
-For more details, refer to the following article: <a class="​postlink" ​href="​https://​docs.microsoft.com/​en-us/​sql/​database-engine/​configure-windows/​configure-the-max-worker-threads-server-configuration-option">​https://​docs.microsoft.com/​en-us/​sql/​database-engine/​configure-windows/​configure-the-max-worker-threads-server-configuration-option</​a>​+<​br>​ 
 +<​br>​ 
 +For more details, refer to the following article: <a href="​https://​docs.microsoft.com/​en-us/​sql/​database-engine/​configure-windows/​configure-the-max-worker-threads-server-configuration-option">​https://​docs.microsoft.com/​en-us/​sql/​database-engine/​configure-windows/​configure-the-max-worker-threads-server-configuration-option</​a>​
 <br> <br>
 <br> <br>
 <font color=#​FF0000>​ <font color=#​FF0000>​
 Important: Important:
-</​font>​+
 <br> <br>
-Please consult with an experienced database administrator or certified SQL Server technician before making any change to the maximum worker threads.+Please consult with an experienced database administrator or certified SQL Server technician before making any change to the maximum worker threads.</​font>​ 
 + 
 + 
 +</​font></​li>​
 </​html>​ </​html>​
  
  
 ===== Keywords ===== ===== Keywords =====
-MS SQL Server, worker threads, max, databases+mssql, sql, worker threads, max, databases
public/8086_issue/vss_e_writererror_nonretryable.1605004054.txt.gz · Last modified: 2020/11/10 18:27 by edward.chan

Page Tools