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: )

460 reads

Blogs

Using SQL Compare for One Procedure

By

A customer recently was concerned about the time to run SQL Compare for a...

Daily Coping 11 June 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Azure SQL Database – Secondary Database and Tiers

By

On the theme of failover groups let’s do a quick recap on my environment....

Read the latest Blogs

Forums

Tracking, Privacy, and Lots of Data

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Tracking, Privacy, and Lots of...

Distributed Availability Group setup for DR Standalone SQL server

By dastagiri16

Hi Team, We have primary DC which is having 3 nodes cluster and implemented...

Sql Server 2014 RRS feed

By CarmeloLabadie

Can we configure active passive clustering on sql server 2014 without any licence?

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers