Enmhancement Request: The error information in Maintenance Plan and Job History return similar error messages as those written to the Verbose LiteSpeed Log files. The errors from Version 5.0.1.1060 cannot be easily interpreted by the user.
Steps to duplicate:
LiteSpeed 5.0.1.1060
SQL Server 08.00.2050
New Maintenance Plan (created in 5.0.0.1060)
MP is to backup TransLogs for multiple databases (Full Recovery Mode, Loading, Simple Recovery Mode, Full Recovery Mode)
Job Step:
execute master.dbo.xp_slssqlmaint N'-PlanID 99A55214-4946-4303-BE7E-3628B5AF5803 -BkUpMedia DISK -DelBkUps 1HOURS -BkUpLog "D:\Backup\2000" -BkExt "trn" -NOOPTOLR -Throttle 100 -BufferCount 20 -MaxTransferSize 1048576 -CompressionLevel 1 -Priority 0 -Logging 2 -Affinity 0 '
/**LiteSpeed Data. Do not modify. Version: 1.0.0.326**/
/**H4sIAAAAAAAEAO29B2AcSZYlJi9tynt/SvVK1+B0oQiAYBMk2JBAEOzBiM3mkuwdaUcjKasqgcplVmVdZhZAzO2dvPfee++999577733ujudTif33/8/XGZkAWz2zkrayZ4hgKrIHz9+fB8/Iv7SX7NoXmRtcZkf7vzGSZPXl3l9ePz8J/d27n16sPcbJ7OszSZZk//+TV7m07aolr9/e73ixuar5vfP303L9Syf+Z/uHL6o6nZ+VSxn7sPdw9V60ri/9w5fF4tVmf/+X1Sz3H187/D189d7Ozs7z6tpVv7Gyf8DjPtOYaUAAAA=**/
Errors for Pubs (in Loading mode)
Error in LiteSpeed Verbose Log file:
BACKUP LOG is terminating abnormally.
Database ''pubs'' cannot be opened. It is in the middle of a restore.
Error for Simple_Mode (in Simple Recovery Mode)
Error in LiteSpeed Verbose Log file:
10/29/2008 2:24:10 PM: BACKUP LOG is terminating abnormally.
The statement BACKUP LOG is not allowed while the recovery model is SIMPLE. Use BACKUP DATABASE or change the recovery model using ALTER DATABASE.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center