Anybody know how to set up an automatic differential backup on SQL7 server? The maintenance plans only let you do a complete and transaction log backup.

I prefer to do full backups so I've never done auto diff ones but it looks like it is possible - curiously not via the Maintenance plans but via the manual backup - it has a schedule option (its the same on SQL2000 as well as 7)

Good luck

How to create a differential database backup (Enterprise Manager)

• Expand Databases, right-click the database, point to All Tasks, and then click Backup Database....
• On the General tab, in Name, enter the backup set name.
• In Description, enter a description of the backup set.
• Under Backup, select Database - differential.
• Under Destination, click Add... to add an existing or create a new backup device, or click Remove to remove a backup device from the list of backup devices to be used.
• In the SQL Server Backup dialog box, under Overwrite, select:
  Append to media to append the backup to any existing backups on the backup device.
  Overwrite existing media to overwrite any existing backups on the backup device.
  
• Optionally, select Schedule to schedule the backup operation for later or periodic execution.