PRB: SQL Server Maintenance Wizard Does Not Allow Scheduled Filegroup or Differential Backups (324192)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
  • Microsoft SQL Server 7.0
This article was previously published under Q324192

SYMPTOMS

The SQL Server Maintenance Plan Wizard does not provide functionality to schedule differential, file, or filegroup backups. This option is not available in any of the dialog boxes that are displayed when the wizard runs.

CAUSE

The SQL Server 2000 Maintenance Plan Wizard graphical user interface does not have the functionality to schedule differential, file, or filegroup backups.

WORKAROUND

To work around this problem, you can create Transact-SQL scheduled jobs through SQL Enterprise Manager. For example, follow these steps to perform a differential, file, or filegroup backup:
  1. Open SQL Server Enterprise Manager, and then connect to the server where you want to create the scheduled job.
  2. Point to Management, point to SQL Server Agent, and then point to Jobs. Right-click Jobs, and then click to select New Job....
  3. Type a name for the job in the Name text box.
  4. Click the Steps tab, and then click New.
  5. Type a name for the step in the Name text box. In the drop-down list box, click to select Transact SQL(T-SQL). Click to select the target database for the backup in the Database drop-down list box. To perform the back up, type the Transact-SQL command in the Command text box. For more information about the syntax for the backup statement, see the "Backup" topic in SQL Server Books Online.
  6. Click the Advanced tab, and then type a file name in the Output Filename text box. This file logs the output of the job step. This step is optional. Microsoft recommends that you log the output for troubleshooting for use in case a job failure occurs.
  7. In the Steps dialog box, click OK.
  8. Click the Schedule tab, and then click New Schedule.
  9. Type the schedule you want for the backup, and then click OK.
  10. To create the new backup job, in the Job Properties dialog box, click OK.

MORE INFORMATION

Scheduled jobs are only executed at the scheduled time if the SQL Server Agent service is running. If you have scheduled jobs, Microsoft recommends that you set the SQL Server and SQL Server Agent services to start automatically at system startup.
Modification Type:MajorLast Reviewed:10/17/2003
Keywords:kbprb KB324192
©2003 Microsoft Corporation. All rights reserved.