Error 507 No valid backup sets found from provided folder

Forum for users of Redgate's SQL Backup tool

Error 507 No valid backup sets found from provided folder

Postby aaditya2000 » Fri May 04, 2012 6:02 pm

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.

Posts: 4
Joined: Fri May 04, 2012 5:59 pm

Postby petey » Sat May 05, 2012 1:08 pm

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:

Code: Select all
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
Posts: 2357
Joined: Sun Apr 24, 2005 11:34 am

Return to SQL Backup Previous Versions

Who is online

Users browsing this forum: No registered users and 2 guests