There is a patch build, 220.127.116.11, that skips the actual moving process when the source and target file names are identical. This is presently the least-impact workaround for this issue, taking advantage of the workaround jeffn mentioned. Thus, if you want SQL Backup to proceed to the next backup set when an earlier backup set has been restored, but you don't want to move the trx log backup files out from the present locations, use the MOVETO option with the same folder name as the original files e.g.
- Code: Select all
EXEC master..sqlbackup '-sql "RESTORE LOG AdventureWorks FROM DISK = [g:\\backups\\AdventureWorks_log_*.sqb] WITH STANDBY = [g:\\standby\\AdventureWorks.und], MOVETO = [g:\\backups\\]"'
You can download this patch from
ftp://support.red-gate.com/patches/sql_ ... _2_2_8.zip
Please note that this patch release has not been as extensively tested as a regular release, so use at your own risk.