Differential Backup

Is there away to create differential with SQL Server 2000
Enterprise Edition with the Database Maintenance Plan?
If not how would I create a differential backup job that I
create a full backup on Sunday and daily differentials and
transaction logs every 3 hours.
Database Name : NewOrleans_Sales
Backup Directory : K:\NewOrleans_Sales
Please help me resolve this backup issue.
Thank You,
Mark E.Hello Mark
Database Maintenance Plan does not provide facility to create differential
backups. If you would like to include differential backups in your disaster
recovery plan then you can configure a simple T-SQL job that can run a
BACKUP DATABASE command to perform the differential backup. You can still
use the Maintenance plan to create the complete and transaction log backups
as you desire.
The command text would be something like :
BACKUP DATABASE NewOrleans_Sales TO DISK = 'K:\NewOrleans_Sales\Diff.Bak'
WITH DIFFERENTIAL
Please note that the above command will create a file Diff.bak and will
continue to append to this same file each time a backup is performed. At
some point you should refresh this file, so as not to fill up the drive.
Please refer to BOOKS ONLINE topic on Backup for more information on this
command and other options that can be used.
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.