Error received:
"Error: No audit log entries were found in this backup file or query returns blank output. Audit logging is OFF by default and must be enabled in the t-sql for individual backup jobs"
Audit logging was not enabled when the backup file was created by LiteSpeed. The audit log is created at the same time the backup is created.
Audit logging is turned off by default. Audit Logging can be reenabled for individual backups by adding @auditlog=1 in TSQL or --auditlog to the command line.
Example t-sql: exec master.dbo.xp_backup_database
@database = 'Pubs',
@filename = 'D:\Backup\Pubs200606250912LiteSpeed_Full.BKP',
@backupname = 'Pubs backup',
@desc = 'Backup of Pubs on 2006-06-25 09:12:14',
@auditlog=1,
@logging = 2,
@with = 'SKIP'
To view audit logs:
In LiteSpeed Enterprise Console, right-click in tree, select 'Audit Log', select backup file containing audit log.
In Query Analyzer: exec master.dbo. xp_view_sls_auditlog @filename='C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\Northwind.bak'
NOTE: This feature is only available for backup files created by LiteSpeed; Native SQL and files created via Native Command Substitution will not create audit log files.
NOTE: This feature was removed in 5.0
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center