1

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: enter image description here

enter image description here

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
6
  • 2
    Are you able to successfully use BACKUP DATABASE ... TO DISK = 'path to some file.bak'; to do the backup?
    – Hannah Vernon
    Nov 5, 2015 at 22:09
  • 1
    The associated graphics are the log result from using the GUI and TSQL. The short answer is no.
    – AKDiscer
    Nov 5, 2015 at 22:10
  • Does DBCC CHECKDB show anything bad for the database in question? Are you able to backup master?
    – Hannah Vernon
    Nov 5, 2015 at 22:16
  • 2
    3041 is a generic message. Refer to this KB for troubleshooting
    – Kin Shah
    Nov 5, 2015 at 22:21
  • @SeanPerkins You state Regardless 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 through Maintenance Plan. Please do as Max suggested with that METHOD (and TSQL example) and post your results to ensure it's not some Maintenance 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. Nov 6, 2015 at 2:34

1 Answer 1

0

I forgot to update this post with what ended up working for me. I don't know why, but running SSMS as Administrator allowed the backup to complete as you'd expect.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.