Problem with latest_all

HenrikFFMHenrikFFM Posts: 4 New member
This worked:

EXECUTE master..sqlbackup '-SQL "RESTORE DATABASE [Henrik_UAT] 
FROM 
DISK = ''D:\Transfer\FULL_(local)_Henrik_*.sqb'',
, DISK = ''D:\Transfer\DIFF_(local)_Henrik_*.sqb''
WITH REPLACE,
PASSWORD = ''<secret>''"'

this produce an Error 507: No valid backup sets found from provided folder(s).

EXECUTE master..sqlbackup '-SQL "RESTORE DATABASE [Henrik_UAT] 
FROM 
DISK = ''D:\Transfer\FULL_(local)_Henrik_*.sqb'',
, DISK = ''D:\Transfer\DIFF_(local)_Henrik_*.sqb'' latest_all
WITH REPLACE,
PASSWORD = ''<secret>''"'

The first read only the FULL and ignore the DIFF.

What is wrong ?


Sign In or Register to comment.