How to set full and differential backup in sql server 2000

I want to set a full and differential backup to one database in sql server 2000.

Is there a way to set both full and differential to just one database.

i want the full backup weekly once and differential every day to set up.

Please let me know

Yes it is possible to set as you said........you can schedule it as a 2 seperate jobs.......one job will take diferential backups from mon-sat and other will take full backup on sunday........you can schedule as per your desire on any day........ i just gave a sample........
1. you can use the maintenace plan in sql 2000 to create backup job or
2. you can use your own backup script which can be used in the job which you create in sql 2000

refer the below link,
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx#ELYAG
|||

Hi,

It *depends* upon the requirement, but in general its good to have

Weekly Full backup

Daily Differential Backup

Half Hourly/ Hourly (depends upto size of your db) t-log backup , so that you can recover your database point-in-time

Here are some good article for your referrence

http://www.dbazine.com/sql/sql-articles/larsen12

http://support.microsoft.com/kb/329833

http://search.techrepublic.com.com/search/Backup+and+Microsoft+SQL+Server+and+strategy.html