Here is the code that I use to get failed backups. You may be able to use it:

CLEAR

[System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.SMO') | out-null

# Initialize Arrays

$InstanceList = @()

$NoBackups = @()

# Don't check...

Thanks all, for the responses. I think we are starting to stray from my original questions, into general DR. We are trying to understand how we can, or if...

and the light bulb goes on. Yes, Steve, you are correct, we are testing our production systems. If we were truly DR, then the Always On is actually a good...

There are lots of solutions, but other than the SAN replication, we haven't really found a better solution.

We use log shipping for a couple of databases for DR purposes,...

Thanks for the response. I do in fact appreciate it. I wanted to get a conversation going, to see how others are using Always On, and how they use...

SQL Agents are per instance, as Steve has said, however, they fail over with the instance, as long as it's in the same cluster group as the instance.

Leonard

Thanks Joie.

Yes, I had already read those links, and unfortunately, they didn't answer my questions.

I will keep digging, or maybe just try it and see what happens.

Leonard

My suggestion would be to use Ola Hallengrens scripts. You can find it here, https://ola.hallengren.com

Leonard

Straight to html, you can use something like this, combined with the code I previously posted.

# Use this for reporting, if not emailing

$InstanceVersList | Select @{Name='Instance Name';Expression={$_.InstanceName}}, @{Name='Server Name';Expression={$_.ServerName}},...

Here is what I use. It runs on a daily basis. It sends 2 emails. One, listing just the jobs we DBA's are interested in, retrieved by category. The second...

Hi,

As for where the details should be stored, that is up to you. I typically run my reports from a SQL Server instance, so I use a table that has...

As has been stated before, you should probably set up a backup job, on each server, using regular t-sql. No need to do the backups from a singular location. ...

I have some code that may be useful. To get your instance list, db names, etc, you can do something like this. I have cleaned up the code a...

I found it my issue. It seems the trigger generated thousands of emails, that ended up in my SQL unsent email table, and SQL was sending those. so even after...

Just my 2 cents, and it has been a while since I attempted to use a synonym. Thought it would be useful, created some for test, then tried to...