This is a  post to the more appropriate forum of the question asked in Metrics/Order Detail -MSSQL, in which you were repeatedly, politely asked NOT to post excel file...

https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

Posting consumable DDL & data serves several purposes:

• It saves time for the people whom you are asking to help you.
• It protects the people whom you are asking to...

https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/database-level-roles?view=sql-server-ver15

Only db_ddl_admin & db_owner roles inherently have create table permissions.

db_datareader, db_denydatareader, db_datawriter, & db_denydatawriter roles do not.

1. No, you can't restore from a newer version to an older version. You would have to rebuild the database -- scripts, Copy Database wizard in SSMS, Export Data, etc.

2....

It would help if you provided DDL and insert statements for data... and if your query column names matched those you provided in the table descriptions -- WorkCenterName != WCName

Given...

TLDR: Analyze server specs, compare to actual workload, & test consolidation.

It's not really about the version of SQL Server, but about the size/rate of transactions (inserts, updates, deletes), the size/rate...

Is the font installed on the server where SSRS is running?

That is where the export takes place, and where the font has to be embedded in the PDF. Font embedding...

Not sure what you mean by generic, but a report with barcodes doesn't sound generic.

How are the bar codes generated? Given the behavior, I suspect they are using a bar...

Check out Milleniata's M-Disc if you're interested in archival media (claims of 1000 years) for photos. Still only a maximum of 100GB/disc, and obviously no guarantees of the technology...

Copy & swap should work. but don't forget to copy permissions too so that SQL Server has the same permissions to folders/files on the new drive.

It won't impact anything that references the view (except when you have to drop & recreate it).

You have to drop & recreate schemabound view if altering source table(s): https://docs.microsoft.com/en-us/sql/t-sql/statements/create-view-transact-sql?view=sql-server-ver15

Views or tables...

Permissions are granted on schema, not individual tables: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-sequence-transact-sql?view=sql-server-2016

Requires CREATE SEQUENCE, ALTER, or CONTROL permission on the SCHEMA.

GRANT CREATE SEQUENCE ON SCHEMA::Test TO [AdventureWorks\Larry]

You can query sysjobs for sysjobsteps containing xp_cmdshell or using the CmdExec type:

SELECT * FROM msdb.dbo.sysjobs
WHERE EXISTS (SELECT * FROM msdb.dbo.sysjobsteps 
     ...

SELECT
    reports.name AS ReportName,
    Datasource.Name AS datasource
FROM dbo.Catalog reports
INNER JOIN dbo.DataSource ON DataSource.ItemID = reports.ItemID
WHERE reports.Type = 2 
AND NOT EXISTS...

To add to the idea of future-proofing, the OP might also want to consider using different ranges of IDs for related data to avoid ID collision and make merging into...