From your command it looks like you are using SQL native backup. There are other backup products out there (eg SQL Litespeed) that have as part of their USP the...

When upgrading to a new version of almost anything there are likely to be winners and losers. SQL Server is sadly no exception. New code that improves a majority of...

Your organisation really does need someone whose job is to focus on DB performance and availability. The normal job title for this role is DBA.

There are a lot of aspects...

If this is a sensitive system that your organisation may rely on as evidence in a court case, then be aware that deleting or changing any data in the audit...

There is a limit on the number of rows that can be displayed in a SSMS pane. This is because SSMS is not intended as a reporting tool.

You can check...

For us mere humans, we read IssueNo = 2 as the first condition to be satisfied, and think the convert(...) should only be done if condition 1 is true.

For SQL,...

USE statements can be tricky. I suggest splitting your code into two procs, one to test status and one to do actions.

You could make the test status proc a bit...

If there is no budget for monitoring tools that implies your business does not care if the service is up or down, it just wants things on a 'best-efforts' basis. ...

I am clutching at a straw here, as I have not seen this ctual problem.

I am wondering if there is some level of server-to-server authentication happening that is causing the...

My approach would be to try to isolated where the problem occurrs.

• Does it happen with all connections.
• Does SSMS connect ok.
• Is the problem connection from a process that...

If SQL reports an error, even if you think it is a false positive, you have a problem you need to deal with.

IMHO if you know that a new version...

I do not know DbDefense in any way, but I do know a bit about XPs.

The support for XPs will not disappear overnight. With the current SQL release cycle if...

Jeffrey is definitely on to something.

You can check this by looking at the SQL log on the node that is starting up, this will tell you how long it is...

Most of us know Murphy's law that 'anything that can go wrong will go wrong', but fewer of us realise that Murphy was an optimist.

Back in 2018 we had implemented...

You are going to have to do some troubleshooting.  What do your install logs say about the problem. If you don't know where to find the logs, check out the...