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.

Thanks
aaditya2000
 
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
petey
 
Posts: 2339
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 0 guests