Get your server issues fixed by our experts for a price starting at just 25 USD/Hour. Click here to register and open a ticket with us now!

Author Topic: Cannot open backup device. Operating System error 5 - MSSQL Database backup  (Read 5252 times)

0 Members and 1 Guest are viewing this topic.

sajugovind

  • Guest
While backing up a database from WSP or from Msqlmanagement studio, it fails with error

"Cannot open backup device. Operating System error 5"

Solution:

Kindly make sure that the sql express service is running with user "localhost\administrator"

If not,

You can change the log on for the service from

Run > services.msc > go to the respective service name > right click properties > log on

Here you can change the user that runs the service.

I changed the service to run from localhost\administrator and than I could backup the database without any issue.

Thank you,