success is for the job. The parts of the job might have issues, but depending on your proc, you might report success. Seeing the proc will help, but honestly, there...

You are at risk. You are assuming your full backup file is actually correct and not corrupt. If you restore it regularly, that's better, but image you back things up,...

Performance is more variable. You could read about the differences there. You also don't have the same control. You can't see hardware, and must work on any issues with looking...

You'd have to provide more info about how the job is running and scheduled. SQL Server backups should not interfere with workload, nor should workload interfere with them. Not sure...

Thanks, but these threads are not asking for help. They are asking for authors to write articles for this site.

Thanks, but these threads are not asking for help. They are asking for authors to write articles for this site.

You likely need a trigger. It's hard to explain how to do this in a post, but look at this

https://www.sqlservercentral.com/articles/auditing-through-triggers

use DATEADD in your WHERE clause. you can use this to add 1 and 2 years to the date, and then limit the data returned in an aggregate.]

Something like:

            
April 10, 2020 at 6:28 pm
            
#3742073

            
            
                                                
        

No real timeline for any of these. It's just  a set of things I'm trying to tackle. Not all on this day.

I have a few others, but need to find...

I'm giving away most of my CDs right now. I've gotten used to streaming, most are ripped, and someone else might enjoy them

Hi from the north of England

I take breaks too which makes it easier - I have also been rigid with my work hours and try not to start any...

Hi

I have been working remotely now for the last 3 weeks and so far it has all been good. Though today I need a short "mental health break", which...

I started looking through the Azure Learning Explorer. I should go through some of the Azure fundamentals. Learned quite a bit about Azure SQL, but not the core stuff as...

:), fortunately (for Grant), no.

We're actually really slow to hire and fire. Our CEO told us in Feb not to worry and we could pay...

• This reply was modified 6 years, 1 months ago by Steve Jones - SSC Editor.

It's interesting. A friend was over last night. He has 400+ reports under him. Had to let 10% go at the beginning of the year. Easy to do. Got told...