Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Differential Backups in SQL 7.0

Status
Not open for further replies.

apollo11

Programmer
Apr 5, 2001
35
US
How do I specify a DB maintenance plan in SQL Server 7.0 SP2 to take differential backups? I know you can do differential backups when you backup a DB individually, but here I have a bunch of databases that I have specfified in the maintenance plan to be backed up but I don't see an option where a differential backup can be specified.

Can someone please help? Thanks
 
Unfortunately Database Maintenance Plans only offer to do full or transaction log backups. If you want to automate a differential backup you will have to make a job yourself to do it.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top