I'm not sure exactly what's going on but if you are getting CREATE DATABASE permission denied in database 'master'. it seems like the user it's running as isn't sysadmin. ...

Hi, there is problem with the permissions assigned to the account running the service.  If you are getting this error:

CREATE DATABASE permission denied in database 'master'.

The account it's running as...

Hi, the tool works a bit differently from native log shipping.  There is no copy process to copy the logs from a share on the source instance to a folder...

A basic config would look like this where we configure the destination (where we want the DBs to be restored), and the path of the log backups.

LogShippingService.exe...

If you are using standby mode to read from the log shipped databases, you will need to kill any connections to the standby databases before you can restore additional logs. ...

Extended events tend to be more for diagnostic purposes than monitoring resource utilization.  You can get some info like CPU utilization from XE. Perfmon could be used to capture resource...

I created DBA Dash. It's a Windows service that collects data from your SQL instances into a central repository database.  There is a Windows GUI app front-end.  It will...

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 12 months 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. ...