hahahahahahahahahahahahahahahaha....

I got it right

    Because I knew it
    From a class I took in October

lulz

When splitting data and log files, for performance reasons its been a recommendation for separate spindles....when using rotating disk drives in a non-SAN setup.

Logical volumes still use the...

I've always used this to check physical files to current dbnames

select d.name, m.name, m.physical_name
from sys.master_files m
inner join sys.databases d
on (m.database_id =...

first...Always On doesn't mean anything.  Do you mean Failover Cluster Instances, or Availability Groups?
Second, you need to go check the Microsoft documentation on this, for whichever of the two...

Aaron says it better than I can:

https://dba.stackexchange.com/questions/73324/tempdb-will-not-shrink-no-open-transactions

Toyota North America's new HQ in Plano, TX offers the same thing, and they advertise it all over their LinkedIn recruiting efforts.   Not sure about onsite/WFH mix.  I'm tempted...

Is there anything relating to network protocols or the login failures in the ERRORLOG file?

path similar to:

C:\Program Files\Microsoft SQL Server\MSSQL12.SQL2014\MSSQL\Log

And are you connecting locally...

As VastSQL said, your connection manager for the package is likely pointing to the old server

In addition to Sue_H's answer, check to see if there are indexes on the various tables...2016 has them, older versions do not.  Not sure when this changed.   I've had...

Also look at the size of the backupset table(s) in MSDB....if that old data isn't getting purged it can cause the new info about backups to fail to write to...

" I submit that if I am opening a hex editor on your SQL Server you are already p0wned. "

Bingo 🙂

Another option is to set it to Restricted_user instead of Single.

The semi-colon is a statement terminator...some connection might be getting in between statements is my thinking.  I had...