Restore fails with Error 507: No valid backup sets found

ozbroomyozbroomy Posts: 3
edited March 25, 2014 6:42PM in SQL Backup Previous Versions
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]

Comments

  • 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: [email protected]
  • 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.
Sign In or Register to comment.