BUG: Sqlmaint Does Not Delete Expired Backup Files on Windows 95, 98 or ME Computers (278667)


The information in this article applies to:

  • Microsoft SQL Server 2000 Desktop Engine (MSDE)
  • Microsoft SQL Server 2000 Personal Edition
  • Microsoft Data Engine (MSDE) 1.0
  • Microsoft SQL Server, Desktop Edition 7.0
This article was previously published under Q278667
BUG #: 58453 (SQLBUG_70)
BUG #: 351122 (SHILOH)

SYMPTOMS

When creating a maintenance plan by using xp_sqlmaint, older backups that are supposed to be deleted may not actually get deleted. The -DelBkUps option in xp_sqlmaint does not work on computers that are using Microsoft Windows 95, Microsoft Windows 98, or Millennium Editions that have Microsoft SQL Server 7.0 Desktop Edition, MSDE 1.0, Microsoft SQL Server 2000 Personal Edition, or Desktop Engine, otherwise known as MSDE 2000. The problem exists for SQL Server regardless of the service pack level.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 7.0.
Microsoft has confirmed this to be a problem in SQL Server 2000.
Modification Type:MajorLast Reviewed:12/3/2003
Keywords:kbBug kbpending KB278667
©2003 Microsoft Corporation. All rights reserved.