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 |
|
keremcan
Starting Member
1 Post |
 Posted - 2004-01-23 : 03:23:59
|
| Hello,I need to take daily differential backups of eight databases. I was thinking of using a DB Maintenance Plan, but the problem is it allows only full backups. Is there a simple way of taking differential backups of multiple db's? For example is it possible to modify the full backup query of DB Maintenance Plan and use it as differential? The query of DB Maintenance Plan full backup is like below:EXECUTE master.dbo.xp_sqlmaint N'-PlanID 8CD36FED-A3BC-43D1-91E5-33A8C02A3FEA -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpDB "C:\DB\Backup\2004\full" -CrBkSubDir -BkExt "BAK"'Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-23 : 12:24:52
|
| Why not just write out the BACKUP commands for every database? Why bother using a wizard? Just because the wizard can select multiple databases, doesn't mean that the wizard should be used. To write out commands, do something like this:SELECT 'BACKUP DATABASE ' + nameFROM sysdatabasesORDER BY nameYou'll have to add some logic to it, but there should be enough there to get you started.Tara |
 |
|
|
|
|
|
Differential backup with DB Maintenance Plan