How can we help you today? How can we help you today?

Error 507 No valid backup sets found from provided folder

I am getting error when my restore jobs fails. my restore database name is same as backup database name.

I am restoring from shared location. but when i copy that backup file to local disk. restore works, but fails with that error when i restore from shared location.

Any help is greatly appreciated.

Thanks
aaditya2000
0

Comments

1 comment

  • petey
    When restoring from a network share, you need to ensure that the SQL Backup Agent service startup account has rights to access that network share.

    You can check if that account has read/write/delete rights by running the following:
    EXEC master..sqbutility 999, 'RWE', '<your network share path>
    

    What is the returned result?
    petey
    0

Add comment

Please sign in to leave a comment.