SQL Server Maintenance Plan Backups Failing On Secondary Replica in High Availability Environment

When a High Availability (HA) environment failed over, on the node that became Secondary, the backup jobs did not gracefully handle the change. The Maintenance Plans are supposed to intelligently determine whether each database is Primary or Secondary in an HA environment, and skip the backup if it is not Primary.  This check actually fails (practically speaking) if you have "Verify backup integrity" checked.

Tags: 

TSQL - Make Excel Link In Output

Here is a situation I just came across (boiled down and simplified).  An end user was having to manually find a user id, navigate to an image folder, and then search through hundreds of images to find the one corresponding with that user.  Sure, they were in numerical order, but still, what a pain!  He wanted to generate an excel file with links to files to quickly access the corresponding image. 

Tags: 

Post date
PowerShell - Update All SQL Services To Restart On Failure Thursday, August 4, 2016 - 18:36
PowerShell - Create And Write Out To Log File Thursday, August 4, 2016 - 18:28
Generate Red Gate MultiScript .dat File Thursday, July 14, 2016 - 23:16
T-SQL - Get Listener Name on AlwaysOn Cluster Wednesday, May 25, 2016 - 17:39
PowerShell - Check If Module Is Loaded Wednesday, May 18, 2016 - 23:35
SQL Server - Timestamp Column Monday, May 2, 2016 - 22:42
PowerShell - Get All SQL Instances On Server Wednesday, April 27, 2016 - 21:48
PowerShell - Get "Logon As" Information From Remote (or local) Server Wednesday, April 20, 2016 - 00:45
T-SQL - Get Currently Running Jobs With Duration Thursday, April 14, 2016 - 23:38
Restore All Databases With Most Recent Backup Thursday, April 14, 2016 - 17:17