@ErrorMessage=N'61700 : VDI open failed due to requested abort.
RESTORE LOG is terminating abnormally.
Exclusive access could not be obtained because the database is in use.
WORKAROUND:
LiteSpeed can retry the process by using the parameter “@ioflag” (the info below is from the NetVault LiteSpeed for SQL Server Help file). This parameter works with LiteSpeed backups & restores of full, differentials and logs.
This parameter specifies if LiteSpeed should wait and retry the read or write operation on failure. You can define retry options using the following parameters:
DISK_RETRY_COUNT—Specifies the number of times that a specific operation will be retried on failure. The default is 4 retries, the maximum allowed setting is 1000.
DISK_RETRY_WAIT—Specifies the number of seconds to wait immediately following a failure before retrying. The default is 15 seconds, the maximum allowed setting is 300.
Note: This functionality is only available for disk operations.
Example:
EXEC master.dbo.xp_restore_log
@database = 'database_name'
(, @filename = 'backup_file_name') [,...n]
[, ( @encryptionkey = 'encryption_key' | @jobp = 'encrypted_key' )]
[, @filenumber = n]
[, @with = 'additional_with_parameters'] [,...n]
[, @logging = 0 | 1 | 2 ]
[, @affinity = 0..2147483648]
[, @throttle = 1..100]
[, @ioflag = 'DISK_RETRY_COUNT=n']
[, @ioflag = 'DISK_RETRY_WAIT=n']
[, @buffercount = 'buffer_count']
[, @maxtransfersize = 'maximum_transfe
[, @returndetails = 0 | 1 ]
[, @restoreasreadonly = 0 | 1]
[, @restoreascompressed = 0 | 1]
