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

Does Restore VerifyOnly support wildcards?

This works:
exec master..sqlbackup N'-SQL "RESTORE VERIFYONLY FROM DISK = ''D:\Program Files\Microsoft SQL Server\MSSQL\Backup\File_01.sqb'', DISK = ''D:\Program Files\Microsoft SQL Server\MSSQL\Backup\File_02.sqb''"'

But this doesn't:
exec master..sqlbackup N'-SQL "RESTORE VERIFYONLY FROM DISK = ''D:\Program Files\Microsoft SQL Server\MSSQL\Backup\File_*.sqb''"'

It produces: 
Verifying file:
  D:\Program Files\Microsoft SQL Server\MSSQL\Backup\File_*.sqb

Error 580: Failed to open file.  Message:  (Cannot open file "D:\Program Files\Microsoft SQL Server\MSSQL\Backup\File_*.sqb". The filename, directory name, or volume label syntax is incorrect.
)

SQL Backup exit code: 580


exitcode	580
sqlerrorcode	0
filename01	D:\Program Files\Microsoft SQL Server\MSSQL\Backup\File_*.sqb
Bernard Sheppard
0

Comments

1 comment

Sort by
  • petey
    No it does not. Sounds useful to me.
    petey
    0

Add comment

Please sign in to leave a comment.