Error 507 No valid backup sets found from provided folder

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

Error 507 No valid backup sets found from provided folder

Postby aaditya2000 » Fri May 04, 2012 7: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 6:59 pm

Postby petey » Sat May 05, 2012 2: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 7
petey
 
Posts: 2233
Joined: Sun Apr 24, 2005 12:34 pm


Return to SQL Backup 6

Who is online

Users browsing this forum: No registered users and 0 guests