"Log backup" is the wrong way to look at it. It's what SQL is waiting on to be able to truncate the log.

That may be a backup. It...

Y I know it doesn't work for repl, but I've never tried before with the mirroring mon...

well then, you may be putting together your own monitor in code.

If the log won't shrink there's a reason. Here's how you find out why:

select name, log_reuse_wait_desc from sys.databases

That'll tell you what it's waiting for to be able to shrink.

Yeah, google how to setup a sql alias.

You can't shrink a log by detaching a DB. It sounds like you just need basic log mgmt. training.

I've got a session where I talk about basic log mgmt....

Yep, that's why I have him a list of things that typically slow down dist.

The best way? Well that really depends on how complicated the pkg is and what it does.

However, I'll say that for anything other than the simplest pkgs I'd use...

Agreed. I think this is the perfect use for a view.

If you're running it from SSISDB then you can find the errors by right-clicking on the report or project and running the report. It'll show you errors for all...

Still all of those scenarios make me nervous. What happens when you go to restore and this month's file is corrupt? Nope, I don't like it one bit. ...

You've managed to misunderstand me. I was talking about indexes in Dist, not your user DBs.

it depends on what's wrong now doesn't it?

Without looking anything up and just going with my gut I would guess that maybe your AG wasn't pushing data and it was filling up the log.

This is where the...

Removing the primary would have been the last resort.

I would have done the following, probably in order:

1. Check what's holding up the log truncation with

select name, log_reuse_wait_desc from sys.databases

If it...

If your log backups weren't doing any good then you probably had a large xact that was spanning across all of them. Or maybe one was left open.

Otherwise, there...