Microsoft KB Archive/242500

= BUG: Sqlmaint Does Not Report Error on BACKUP LOG When Truncate Log on Checkpoint is Set =

Article ID: 242500

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q242500



BUG #: 56515 (SQLBUG_70)



SYMPTOMS
The sqlmaint utility does not generate a message when attempting to back up the transaction log from a database that has the truncate log on checkpoint option set. This is also true when using the Database Maintenance Plan Wizard.

The backup of the log takes place and a blank file is created. However, if you run the backup by using the SQL Query Analyzer, the following error message occurs:

Server: Msg 4208, Level 16, State 1, Line 1

BACKUP LOG is not allowed while the trunc. log on chkpt. option is enabled. Use BACKUP DATABASE or disable the option using sp_dboption.

Server: Msg 3013, Level 16, State 1, Line 1

Backup or restore operation terminating abnormally.



WORKAROUND
You can get SQL Server to report an error message if you have it write to either an HTML file or to a table in the msdb database. Use the following Sqlmaint.exe parameters:
 * HtmlRpt, which writes to an HTML file.

-or-


 * WriteHistory, which writes a history to msdb.dbo.sysdbmaintplan_history.

For example: C:\MSSQL7\Binn>sqlmaint -D pubs -S servername -U sa -BkUpLog "c:\temp\pubslog.bak" -BkUpMedia DISK -UseDefDir -HtmlRpt "c:\temp\sqlmaint.htm"



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.

Keywords: kbbug kbcodesnippet kbpending KB242500

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.