PS: *smart aleck on*

regarding "every Editor on this planet has File | Save" - vi or (if you like DOS more than Unix / Linux) edline have no File...

You never need to truncate the logs, but I think you get this now.

You can delete the log backups on Mon after Wed's full backup for space reasons, but the...

Yes, he would.\

Yes, you have control over the files, so Backup Pro will do it all. If you have the files made with Veem, you can manually restore TL10-27.

You're looking at two things. Catching corruption is running DBCC often. SQL Backup pro can do this. You can run the dbcc often, daily, and detect corruption early.

Restoring is separate....

I completely agree it should be built in, especially as VS includes VCS support. However, I'm not sure the hoops are a good reason to not use a VCS.

Network team needs to lock this down. Having access from local laptops to production is a bad idea, not the least of which is because of ransomware. Access to prod...

Run a test, look at blocking with drop and create v rebuild. Add some activity on the table while you do this. If that doesn't help a developer understand, document...

I'll throw SQL Backup Pro in the mix. Not sure of the cost for you, but you'd have to ask. https://www.red-gate.com/products/dba/sql-backup/

However, I think Ola's scripts with some simple scripting/alerting...

Better get a thorough review of hardware and start ensuring backups are up to date. This is almost always hardware somehow causing a corrupt write in the filesystem.

Double check all...

Use AES. You'll have to decrypt, encrypt your data, but it's more secure.

I'm slightly confused about your problem. Full backups never truncated the log. They include part of the log, but you've always needed a log backup to get file reuse and...

I see this a little, and Microsoft does. Hence their investment in some PostgreSQL tools with ADS and other Azure services.

What I find often is that someone is short sighted....

Fillfactor, collation, some other change?

Do you have to look at your orders in some sequence? Meaning, I might need 5 Product3 and 2 Product4 for an order, but also 2 Product3 and 4 Product4...