Admin-Ahead Community

Windows => Control Panels => WebsitePanel => Topic started by: sajugovind on July 19, 2014, 08:51:23 pm

Title: Cannot open backup device. Operating System error 5 - MSSQL Database backup
Post by: sajugovind on July 19, 2014, 08:51:23 pm
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,