How about here:

https://www.sqlservercentral.com/stairways/stairway-to-alwayson

Thank you. Looking at the databases about three have service broker set as false or 0. Would this be the cause of the message? Also, does it need to...

I googled this: "Powershell determine if SQL is installed"

This looked like a good result

https://mikerodionov.com/2019/04/powershell-script-detect-installed-sql-server-version-and-switch-to-appropriate-setup-directory/

As well as this:

https://docs.microsoft.com/en-us/powershell/module/sqlserver/get-sqlinstance?view=sqlserver-ps

Indexes are probably the 3rd or 4th thing to change.  The query needs to...

The owner should be sa

I am trying to build an extract of backup files(full,diff,log) along with locations(without file names as in the query provided here) usingbackupset and backupmediafamily tables.(past 7 days of days...

No, I do not have an alert on this.  I do watch these things.

In order for any of these to be an alertable metric, you would need to capture a...

What are you trying to do?

A more complete description of the entire set of things you are trying to accomplish may help us help you with a better solution.

Same question from me.  As well as why are you still using an ntext data type?  That was deprecated with...

Created a listener. The first time it failed over there was still one database that was registering the errors on the secondary. It cleared later. A couple of other...

These articles may help:

https://www.sqlservercentral.com/articles/cross-tabs-and-pivots-part-1-%e2%80%93-converting-rows-to-columns-1

https://www.sqlservercentral.com/articles/cross-tabs-and-pivots-part-2-dynamic-cross-tabs

Same question from me.  As well as why are you still using an ntext data type?  That was deprecated with SQL 2005.

ntext...

There's a lot here.  I'm not sure I am 100% clear about what you are looking for. I will take stab at what I think I understand you...

Does this get you closer?

SELECT @@servername [ServerName], 
       SDB.name [DatabaseName], 
       BS.backup_start_date [BACKUP START], 
...

• This reply was modified 5 years, 2 months ago by Michael L John.

Apologies, I was not clear entirely in my first post.

I got the table result from msdb.dbo.backupset, master.sys.sysdatabases and msdb.dbo.backupmediafamily.

I am trying to draw inference from the results and see...