Unable to create/restore backup of MSSQL database: Not valid backup

Created:

2016-12-21 19:17:16 UTC

Modified:

2017-08-16 08:41:04 UTC

1

Was this article helpful?


Have more questions?

Submit a request

Unable to create/restore backup of MSSQL database: Not valid backup

Symptoms

  • Unable to create or restore MSSQL database via Plesk GUI:

    Unable to restore database 'databasename' 
    
    
    Not valid backup: Cannot open backup device 'C:\Program Files (x86)\Parallels\Plesk\Backup\example.com\databases\databasename\database_name.bak'.
    Operating system error 5(Access is denied.). VERIFY DATABASE is terminating abnormally.
  • MSSQL Server is running under NetworkService account.

Conditions

NetworkService account account doesn't has all deny permissions on C:\Program Files (x86)\Parallels\Plesk\Backup\ folders.

Resolution

Switch Log on from NetworkService account to Local system account in Services > SQL Server > right click > properties > Log On

Have more questions? Submit a request
Please sign in to leave a comment.