Multiple file log restore fails on earliest log
Restoring transaction logs for database Bigben from "\transactionlogs\*.sqb"
Processing log group 176426093 ...
\transactionlogs\LOG_(local)_Bigben_20050701 040003.sqb Completed.
Moved LOG_(local)_Bigben_20050701 030002.sqb to \transactionlogs\processed\.
Moved LOG_(local)_Bigben_20050701 040003.sqb to \transactionlogs\processed\.
Msg 3259, Level 16, State 1, Server xxxxxxx, Line 1
The volume on device 'SQLBACKUP_176389181' is not part of a multiple family media set.
BACKUP WITH FORMAT can be used to form a new media set.
Msg 3013, Level 16, State 1, Server xxxxxxx, Line 1 RESTORE LOG is terminating abnormally.
Process Exit Code 0. The step succeeded.
I use the following command (pathnames removed here as well)
SqlBackupC.exe" -SQL "RESTORE LOG [Bigben] FROM DISK = '\transactionlogs\*.sqb' WITH STANDBY = '\UNDO_Bigben.DAT', MOVETO = '\transactionlogs\processed'"
If I go back and put the earliest log file (LOG_(local)_Bigben_20050701 030002.sqb) in the directory by itself and re-run the job, it works fine. I can then take any number of logs that accumulate thereafter, put them in the restore directory, and it will restore all of them at once without a problem.
Very puzzling. Moreover, I'm not using multiple media sets or media families to my knowledge, just a regular SQLBackup command with the COPYTO option to create log backups.
Any advice greatly appreciated! Thanks.