Backup database query with OS error 5

Question

I'm trying to run a backup query:

BACKUP DATABASE MY_DATABASE TO DISK='C:\Users\me\Desktop\POD2013-05-14.bak'

But I get the following error:

Cannot open backup device 'C:\Users\me\Desktop\POD2013-05-14.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 15105).

I thought it has to do with permissions, but log in as sa and Administrator (Win Auth) doesn't solve the problem.

Can anyone help me with this?

possible duplicate of SQL server 2008 backup error - Operating system error 5(failed to retrieve text for this error. Reason: 15105) and many other similar questions. The SQL Server service account needs to have access to the path, and usually only your account can access your own desktop. It would be best to use a different folder, and grant the SQL Server service account access to it. — Pondlife
– Pondlife, Commented May 14, 2013 at 14:33

Hasib Tarafder · Accepted Answer · 2013-05-25 15:33:15Z

1

You need to check the security permissions on the folder you are trying to backup. Make sure the service account (Network Service) has write permissions.

I think your problem might be okay.

answered May 25, 2013 at 15:33

Hasib Tarafder

5,8133 gold badges33 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Backup database query with OS error 5

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related