Log shipping IS transaction log backups.

Here's a suggestion.  Instead of taking the backups with Commvault, use native SQL backups to a disk or UNC, and then set up Commvault to...

Having been to a few conferences, and maybe one or two (!) online presentations, I tend to stay away from the talks given by employees of a vendor.  There are...

No, do your restores

What specifically have you tried?  What specific errors have you received?

2008 R2 didn't have availability groups, so your options are log shipping, mirroring, or replication.

How much downtime can you endure?  How big are your databases?  If they are small, backup,...

I think all deadlocks are good.  Job security.

I'm having an issue on 2016 and 2017... If you have 2019 or any version prior to 2016, would you run the following code, please, and let me know...

I have one SQL 2008 R2 left, 3 - SQL 2012, the majority are 2016 with 4 or 5 2017/2019 instances.  I shut off the last 2005 box.

The issues are...

Duplicate post.  https://www.sqlservercentral.com/forums/topic/select-query-30

Please don't cross post.

That price is about right.   And, a Google search of "Direct Deals Ratings" turns up quite a few opinions of them.  It appears that they are at best, OK.

If it's...

Have you considered using BCP to export all the records, rename the old table, create a new table with the corrected data types, and then BCP in all of the...

Regardless of what scan tool you are using, the results and recommendations are based upon very GENERIC recommendations.   It's reporting to you that a proc is executing at start up. ...

It has nothing to do with the credentials.  Your local security policy is likely set to not allow impersonation.

Are you really posting actual data...

Because you can only upgrade 2 previous versions. 2019 will upgrade 2017 and 2016.

If you must upgrade, as opposed to a fresh install and migrate, you will need to upgrade...