Technical Article

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

461 reads

Blogs

Storage Field Day 23 – SIOS

By

I am thrilled to have been a part of this year’s Storage Field Day...

Getting a list of the articles in a publication.

By

The other day I was asked to supply a list of all of the...

Daily Coping 17 May 2022

By

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

Read the latest Blogs

Forums

SQL FileStream - Concurrency support

By balaece25

Hi team, We have already enabled a SQL filestream for storing API request and...

SQL FileStream - Concurrency support

By balaece25

Hi team, We have already enabled a SQL filestream for storing API request and...

AG Availability mode changed from Asyn to Synchronous

By SQL_Hunt

Hello Is there any good query available to find when the AG mode is...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers