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...
-
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).
-
NONE of my SQL Agent Jobs failed according to the SQL Agent Log for the last two days.
-
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.
-
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