Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-22 : 20:20:34
|
kjkozinski writes "I'm running SQL Server 7 SP2 on Windows 2000. I would like to automate my differential database backups using the "Maintenance Plan" wizard.
Currently, the diff. BKUs run through scheduled jobs created by the "Backup Database" wizard. I'd like to move these to Maint. Plan because it creates distinct files for each backup automatically. Additionally, it automatically purges old backup files from disk.
I created scripts to do these functions, but it would easier to support if SQL Server could do it instead.
Is there any way to schedule diff. backups in SQL Server 7 Maint. Plan? Does SQL Server 2000 allow this?
Thanks for your help." |
|
|
|
|
|
Automating Differential Database Backups?