What are the challenges you face when working across database platforms? Take the survey
Options

Error 507 No valid backup sets found from provided folder

aaditya2000aaditya2000 Posts: 7
edited May 5, 2012 9:08AM in SQL Backup Previous Versions
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

Comments

  • Options
    peteypetey Posts: 2,358 New member
    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?
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.