Problem with latest_all
HenrikFFM
Posts: 4 New member
in SQL Backup
This worked:
The first read only the FULL and ignore the DIFF.
What is wrong ?
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).
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 ?
