LiteSpeed 8.8 Log Backup job Hangs

SQL Agent job created using the Litespeed 8.8 Wizard.

The job is for log backups of all 'USER' databases. Runs every 15 minutes.

Job is as follows:

declare @script nvarchar(4000)
set @script = N'
exec master.dbo.xp_backup_log
@MultiDatabaseType = N''USER'',
@progressname = N''dfd619be-cc9d-48ba-9412-1f546f50f912'',
@backupname = N''%DATABASENAME% - Transaction Log Backup'',
@desc = N''Transaction Log Backup of %DATABASENAME% on %Y-%m-%d %I:%M:%S %p'',
@compressionlevel = 2,
@filename = N''X:\DD301Server\TrxnLogBackups\%D_%T_%z.bak'',
@init = 1,
@OLRMAP = 1 ,
@with = N''STATS = 10'''

exec (@script)

/**LiteSpeed Data. Do not modify.**/
/**H4sIAAAAAAAEALPJLPZLLMksS7U24OVKSSxJTEosTo0vTs1JTS7JzM+LL6ksSLU25uUqTi0qSy2ydnExNjB0cTIwdPYx4uUCALzCIeE9AAAA
**/

Normally, all is well and all the desired log backups are created.

Approx once per week, the job hangs. By 'hangs' I mean, the job shows running, but no log backups are created. At the same time as the failure a '.lsm' file is written to the destination folder for the backups.

After the failure, the SQL Agent job fails to run (because it continues to show 'running' in wont start).

Questions:

What is going on here?

What to do with the .lsm file?

Thanks!

0 ben over 5 years ago

Hello ,

Please open a support case.

It is possible you have an issue that has already been identified, but we would need to verify.

Thanks

-Ben-
- 0 ben over 5 years ago in reply to ben
  
  Also for this question..
  
  stephen merkel said:
  What to do with the .lsm file?
  
  The LSM file is created as part of the parameter "OLRMAP=1".
  
  Normally it is attached to the backup file upon completion of the backup process.
  
  In your case since the backup does not complete the LSM file is not attached.
  
  Please feel free to delete this file.
  
  Hope that helps
  
  -Ben-