This doesn't sound right - there has to be something else affecting the query.

If I understand what you are stating:

1. Compatibility set to 120 - runs fine
2. Switch to 150...

Jeffrey, so talked to the boss. he does want a total failure count and may want a Diff column too later. I will work on that.  If I get...

Scheduling a database shrink is a bad idea and should be avoided.  There are times when performing a manual shrink may be necessary - but it should only be done...

Generally you see that kind of behavior when SQL Server has to load the data from disk into the buffer cache.  Are you - by chance - restarting SQL Server...

The problem is actually quite simple - you are grouping by FailureCount.  So you are getting a failure count for the 1st, the 15th and the last day = 3...

I think you have something incorrect in your grouping statement - or there are some hidden characters/spaces in one or more of the columns that is causing those values to...

Every day on 2 separate systems in 2 different data centers

Yes, those are the daily full backups.  We backup from a synchronous secondary in an AG, both full and log backups.

Because we are backing up from a secondary we MUST...

Daily full backups, log backups every 10 minutes.

6TB for one database, 10TB+ for the system.  About 3 hours to back up all databases.

Update: I was mistaken - closer to 7TB for the one database and 11TB+ for...

• This reply was modified 3 years ago by Jeffrey Williams.

https://www.sqlservercentral.com/forums/topic/create-html-email#post-3889947

https://www.sqlservercentral.com/forums/topic/create-total-record-in-html-email

Review both of these - from these you should be able to put together a template that works for your requirements.

Unfortunately I need to deploy to the file system for this particular project. I think switching from project deployment to package deployment was the missing link I needed. I...

Ok... so what do you do instead?  Just T-Log backups for a week?

I've not yet seen where a DIF becomes as large a Full, yet, especially when you have...

I missed a closing parentheses:

Declare @previous_date  date = iif(day(getdate()) > 16, dateadd(day, -1, getdate()), eomonth(getdate(), -1));

Your change does not handle your requirements and would require manually...

My "general" recommendation for backups is...

1. Full Backup once per week.
2. Dif Backup once per day.
3. "Conditional" Log file backups every 15 to 30 minutes.

Of course, that's subject to...