Restore fails with Error 507: No valid backup sets found

Compresses, encrypts, secures and monitors SQL Server backups.

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

Restore fails with Error 507: No valid backup sets found

Postby ozbroomy » Fri Mar 21, 2014 12:01 am

This is the code SQL Backup 7 generates for a Scheduled Restore...

DECLARE @exitcode int
DECLARE @sqlerrorcode int
EXECUTE master..sqlbackup '-SQL "RESTORE DATABASE [TCM] FROM DISK = ''\\\\server_path\\backup_path\\App_name\\*.bak'' SOURCE = ''dbname'' LATEST_ALL WITH RECOVERY, DISCONNECT_EXISTING, MOVE DATAFILES TO ''E:\\DB'', MOVE LOGFILES TO ''F:\\USERDBLOGS'', REPLACE, ORPHAN_CHECK, CHECKDB = ''NO_INFOMSGS, ALL_ERRORMSGS''"', @exitcode OUT, @sqlerrorcode OUT
IF (@exitcode >= 500) OR (@sqlerrorcode <> 0)
BEGIN
RAISERROR ('SQL Backup failed with exit code: %d SQL error code: %d', 16, 1, @exitcode, @sqlerrorcode)
END

I am getting the following error...
Error 507: No valid backup sets found from provided folder(s). SQL Backup exit code: 507

Can SQL Backup restore .bak files or do they have to be .sqb files?[/img]
ozbroomy
 
Posts: 2
Joined: Thu Mar 20, 2014 11:54 pm
Location: Australia

Postby Anu Deshpande » Mon Mar 24, 2014 1:33 pm

Thanks for your post.

When backing up at 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 SQL Backup agent account has read/write/delete rights by running the following:

Code:
EXEC master..sqbutility 999, 'RWE', '\\server_path\\backup_path\\App_name*.bak'


Can SQL Backup restore .bak files or do they have to be .sqb files?
Files needs to be *.sqb format to be restored.

Let me know if this helps.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Thanks Anu

Postby ozbroomy » Tue Mar 25, 2014 11:42 pm

I think my issue was in regard to dsik space on the backup drive.
I also created a SQL Backup 7 backup (.sqb), so never confirmed if .bak files can be restored. Hopefully this help someone else.
ozbroomy
 
Posts: 2
Joined: Thu Mar 20, 2014 11:54 pm
Location: Australia


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests