My opinion on this is that it falls into the "it depends" bucket that most database tasks do.

I personally like having the point in time source of truth available in...

I personally have not used it.  How does it handle windows authentication or does it only work with SQL authentication?

As a general rule, I try not to run any app...

Quick google - it depends on if it is ReFS or NTFS.  If ReFS, it should be doing self-healing.  I expect this is true until the disks start failing.  On...

First thing I'd do is chkdsk on the physical disk to rule out disk corruption.

But it sounds to me like some disk based error and likely not a database error. ...

Also, another thought here, since the FULL backups are succeeding without a problem, maybe check the syntax on those vs the syntax on your tlog backups?

I still like having scripts...

My preference with code comments is all code functions (stored procedures, triggers, tables, views, etc on the SQL side, methods, classes and functions on the .NET side) should have a...

You want this to be 0 seconds... a fun challenge, but may not be possible.

How often does this data change?  Are you OK with "snapshot" data rather than realtime data? ...

ScottPletcher is right - LEAD and LAG were introduced in 2012.  I am bad at this recently.  I thought they were a 2016 and newer feature.  Good to know!

I think...

Yeah, for something like backups, I like having short and easy to test/debug scripts rather than "all in one" scripts like Ola's.  That is just my preference, especially since Ola's...

A work around - use shorter filenames for your backups.

I personally don't use Ola's scripts just for the reason you found - if a bug crops up, I either need...

How does this look:

CREATE TABLE [#filetable]
(
[FileID]  VARCHAR(20)
, [GroupID]  VARCHAR(10)
, [Level]  VARCHAR(1)
, [Path]  VARCHAR(255)
, [Filename]  VARCHAR(255)
, [ExpectingResultofPath] VARCHAR(MAX)
);

INSERT INTO [#filetable]
(
[FileID]
, [GroupID]
, [Level]
, [Path]
,...

My opinion (experts correct me if I am off on this) - the "secondary" server when doing log shipping is usually in place for disaster recovery.  If the primary server...

Reading through your SP's something is wrong.  Your "Procedure 1 Data" calls "EXEC Procedure1" twice but puts the data into 2 different tables with 2 different sets of columns.  That's...

according to the documentation for SQL Server 2012 - no:

https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2012/ms143506(v=sql.110)?redirectedfrom=MSDN

Here it says that you are looking at Windows Server 2012 if you want to be in a supported configuration.  That...

I expect that anyone on the forum is going to need more than this.  Since the backup failed, it is obvious (to me) that the restore failed.  Without the backup,...