The postings on this site are my own and do not represent my Employer's positions, advice or strategies.

LifeAsBob - Blog

 

Home

No Ads ever, except search!
Saturday, May 8, 2021 Login
Public

Blog posts for the month of November,2018.
Aaron Connects10/27/2018 6:26:00 AM

Aaron Connects

First Deer

October 27, 2018

 

Eugene Horkay Academic Letter 201711/8/2018 8:18:33 AM

Eugene Horkay

Academic Letter for 2017 school year, awarded in 2018.

SQL Server 2017 cumulative update fails11/3/2018 8:06:56 AM

Patching SQL Server, generally completes without errors, but sometimes, you do get complications.

 

This was in applying sql 2017 CU 11, 14.0.3814, to SQL Server Failover cluster (FCI), with always-on to another SQL Server Failover cluster (FCI), no listener between the two.  Failed on the passive node.

 

The dreaded error below:

 

Message Script level upgrade for database 'master' failed because upgrade step 'msdb110_upgrade.sql' encountered error 3933, state 1, severity 25. This is a serious error condition which might interfere with regular operation and the database will be taken offline. If the error happened during upgrade of the 'master' database, it will prevent the entire SQL Server instance from starting. Examine the previous errorlog entries for errors, take the appropriate corrective actions and re-start the database so that the script upgrade steps run to completion.

 

Finally figured this out to be related to the check box for MS DTS on the properties for Always-On.

 

Supposedly fixed in CU7, but I think not.

 

https://support.microsoft.com/en-us/help/4092554/fix-cannot-use-save-transaction-within-a-distributed-transaction-when 

 

Unchecked the DTC Support for AG Group.

Re-ran the patch, and it completed successfully.

I Love patches !

Thomas 5 pointer 201811/18/2018 8:23:49 AM

Thomas connects with 5 pointer twice !

AR15, with 300 Black out.

Hornady American Gunner Ammunition 300 AAC Blackout 125 Grain Hollow

120lb white tail before being field dressed.

 


Blog Home