Error Log error log

Published on November 24th, 2014 | by Alejandro Cordero

0

Backup Error, Access is Denied – good for all versions, including sql 2014

Error Message:

Msg 3201, Level 16, State 1, Line 1
Cannot open backup device ‘C:\backup\MyDB.Bak’. Operating system error 5(Access is denied.).
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

 

Cause:

Your SQL Server Account does not have permissions to write a backup file in the specified location.

Solution:

1- Check your SQL Server user account by opening SQL Server Configuration Manager

 

2-Check the folder security permissions where you intend to write your backup, the SQL Server service user needs to have write privileges

3- Try to run the backup again

 

 

MSDN Reference: http://msdn.microsoft.com/en-us/library/ms175477.aspx

These are quick references by SQLTurbo, intended for quick review of commands
and quick solutions to common sql errors. This section does not elaborate
on topics deeply. However feel free to comment and we will try to make
suggestions as needed.

 

Also expect to read topics about  sql 2014 , sql tools , tsql tuning , sql performance tuning , sql monitor and more! Also coming soon, our SQL Server online training!

Tags:


About the Author

SQL Server DBA with over 8 years of experience, developer for .Net , Certified Scrum Master and Entrepreneur.



Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Back to Top ↑
  • Sign Up For Our Newsletter

    Stay up to date on the latest from SQL Server products and Features.

    Sign Up Now

    Sign up for mailing list and receive new posts directly to your inbox.

    We promise never to share or sell any of your personal information.

  • Recent Posts

  • Categories

  • Archives

  • Tags

  • Topics

  • Subscribe to our RSS Feed


    sqlturbo.com A SQL Server Web Blog
    Canada, Ontario, Ottawa.
    http://sqlturbo.com

    The Authors