It's the SQL Server account rather than the agent account that needs access to the backup folder (At least for the RESTORE FILELIST command that has the error).  It looks...

Ola Hallengren's solution supports backup to URL - it might be a better option.  This gist helped me get started with it - though it sounds like you...

I created a monitoring tool(DBA Dash)  that can track space of your databases over time.  There are some export to Excel options if you want to do some further...

• This reply was modified 8 months, 3 weeks ago by  David Wiseman.

Daily checks are a great idea - you are on the right track.  You don't want to rely on email alerts alone - it's best to validate that things are...

I have experience with two large systems - one with FILESTREAM blobs and the other using normal blobs.  Both ultimately got migrated out of the database into an...

You might find this script useful which can help decipher the wait resource:

https://github.com/trimble-oss/dba-dash/blob/main/DBADashGUI/SQL/DecipherWaitResource.sql

It's from the open-source monitoring tool I created - DBA Dash.

Something else worth noting.  If there is a chance you might want the DB to run in the cloud on Azure DB or managed instance - FILESTREAM is not supported...

I have experience with two large systems - one with FILESTREAM blobs and the other using normal blobs.  Both ultimately got migrated out of the database into an object store. ...

I wouldn't store the fully qualified path for each file.  The files will probably need to be moved to a different location at some point.  I'd store a relative reference...

I have some experience in this area and I would advise against storing files in the database - using FILESTREAM or otherwise.  This blog post might be worth a...

I created a monitoring tool, DBA Dash that collects VLF counts for your SQL instances.  The GUI has a nice report that shows you the maximum VLF count for...

I had a 160TB db at one point.  A large % was blob data and the associated table was INSERT only. We also had another activity log table that was...

I wrote my own monitoring solution that has recently gone open source.  It might be worth a look (I'm biased, but it's free and open source):

https://github.com/trimble-oss/dba-dash

I would also...

Yeah - I'm using SMO to script the database objects.

Hope this helps,

David

VARCHAR(8000) can store 8000 characters. You can prove...