Mirroring Job Switcher

I wrote this so that jobs associated with a mirrored database will run on the principal and not on the mirror.  Please send your comments on what implications I might be missing - I would appreciate that greatly.This procedure works in conjunction with a WMI alert you will setup in SQLSEVERAGENT -> Alerts ->Mirroring Status […]

2007-09-04 (first published: )

454 reads

Blogs

Life Support 2008 – Audit Logons

By

Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep...

All the signs were there, but we didn’t understand them: an essay on gatekeeping in IT

By

This is the first in a series of posts about gatekeeping in Information Technology...

Read the latest Blogs

Forums

full text search

By Sailor

Trying to understand why when I search for numerics in full text, contains does...

New CVE-2019-1068 vulnerability - is there a patch for MSSQL 2012?

By Andy sql

MSSQL Server 2012 Service Pack 4 is officially supported until 2022-07-12: https://support.microsoft.com/en-us/lifecycle/search?alpha=sql%20server%202012 The new...

SSIS Package/Agent Job Not Failing!!!

By tim.ffitch 25252

I have a package running in SQL 2016 using Project Deployment. One of the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers