This server was recently installed and configured. I was in the process of creating some maintenance plans to backup the logs and DBs on a daily basis. Regardless of my method to perform a full backup, it would fail immediately citing the generic error message
Error: 3041, Severity: 16, State: 1.
This is what I found in the SQL Error Logs:
I've never seen this before and wasn't able to find much during research. I've verified that the associated service account has permissions to the backup folders and there is more than enough space.
Other details
- SQL 12.0.4213.0
- Windows Server 2012 R2 Standard
- VMware virtual machine
BACKUP DATABASE ... TO DISK = 'path to some file.bak';
to do the backup? – Max Vernon♦ Nov 5 '15 at 22:09DBCC CHECKDB
show anything bad for the database in question? Are you able to backupmaster
? – Max Vernon♦ Nov 5 '15 at 22:16Regardless of my method to perform a full backup
, but I don't think you've shown any examples other than what you get when you run throughMaintenance Plan
. Please do as Max suggested with that METHOD (and TSQL example) and post your results to ensure it's not someMaintenance Plan
related issue only. Also, refer to the article per Kin and post the additional logs referred to in that article and post yo your answer.The detailed error messages are written only to the SQL Server error log and to the client application.
Yours seem different from the MS KB examples. – Pimp Juice IT Nov 6 '15 at 2:34