Automatic differential backups for SQL7

[sirthaddeus]

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.

[Mr Chunder]

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.