How can we help you today? How can we help you today?

Problem with latest_all

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 ?


Henrik
0

Add comment

Please sign in to leave a comment.