Red Gate forums :: View topic - Restore fails with Error 507: No valid backup sets found
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

Restore fails with Error 507: No valid backup sets found

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
ozbroomy



Joined: 20 Mar 2014
Posts: 2
Location: Australia

PostPosted: Fri Mar 21, 2014 12:01 am    Post subject: Restore fails with Error 507: No valid backup sets found Reply with quote

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]
Back to top
View user's profile Send private message AIM Address
Anu Deshpande



Joined: 20 Apr 2009
Posts: 691
Location: Cambridge

PostPosted: Mon Mar 24, 2014 1:33 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
ozbroomy



Joined: 20 Mar 2014
Posts: 2
Location: Australia

PostPosted: Tue Mar 25, 2014 11:42 pm    Post subject: Thanks Anu Reply with quote

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.
Back to top
View user's profile Send private message AIM Address
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group