How to T-SQL Finding who attempted to backup the “master” database?

#1

I am new to SQL Server. I am running SQL Server 2016. For the last two nights at 7 pm the SQL Server Alert System sent me this alert:

'Severity 016: Miscellaneous User Error' DATE/TIME: 8/8/2018 7:02:19 PM DESCRIPTION: BACKUP failed to complete the command BACKUP DATABASE master. Check the backup application log for detailed messages. COMMENT: (None) JOB RUN: (None)

I can also see the Backup failure message in the Windows System log.

However...

  1. I don't have ANY SQL Agent jobs that attempt to back up the "master" database (I have since added one since I think I need one, but I've set that to run on Saturdays at 2 am).

  2. NONE of my SQL Agent Jobs failed according to the SQL Agent Log for the last two days.

  3. NONE of my maintenance plans reported an error according to the Maintenance Plan History. The only maintenance plan running at 7 pm was an Hourly Transaction Log backup of NLProduction (a User Database), it doesn't touch the master database or any of the system databases.

  4. The SQL Server Log (Current - 6/7/2018 8:56:00 PM) shows the same error message saying the backup failed.

I can't find WHY the backup failed because I can't find the log of who initiated the backup. Any suggestions as to how to find WHO attempted the backup and WHY it failed?

Thanks & Regards
Camillelola

#2

Hi,

whilst there are lots of technically minded people on this forum, the main purpose of the forum is Node-RED and not providing support for other application such as SQL Server.

Sorry, but you'll probably need to ask this question elsewhere to get the help you need.

#3

Hi Knolleary, Thanks for your reply.