BUG: Sqlmaint Does Not Report Error on BACKUP LOG When Truncate Log on Checkpoint is Set (242500)
The information in this article applies to:
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.
| Modification Type: | Major | Last Reviewed: | 10/16/2002 |
|---|
| Keywords: | kbBug kbCodeSnippet kbDSupport KB242500 |
|---|
|