Redirected restore of a SQL database with snapshot fails if the SQL Server system administrator account is being used

  • Modified Date:
  • Article ID:000019982


While restoring a SQL database to a location other than the default SQL directory, the job fails with an error if the SQL "sa" is being used for the restore operation


Error Message

The restore operation fails with one of the following errors:

  • An error occurred while attempting to recover the database, V-79-57344-38051.
  • The logon account that was provided does not have valid credentials. Ensure that the user name and password are correct, and then try again. V-79-57344-39777.


The SQL "sa" account being used does not have the appropriate credentials to access the directory to which the data needs to be redirected.



Use a Windows user account that has the System Administrator role on the SQL instance to instead of the "sa" account to perform the restore.




Terms of use for this information are found in Legal Notices.



Did this article answer your question or resolve your issue?


Did this article save you the trouble of contacting technical support?


How can we make this article more helpful?

Email Address (Optional)