Differential backup with database maintenance plan

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"'
ThanksMaint plans doesn't support diff backups. Db Maint does (www.dbmaint.com),
or write your own TSQL command and schedule them using Agent, quite simply
:-).
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"keremcan" <kbuyuktaskin@.yahoo.com> wrote in message
news:2da501c3e183$8843dca0$a401280a@.phx.gbl...

quote:

---

> 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

---

|||Hi,
Here is a link to T-SQL code wrote by Uma Chandar - MVP.
Script to do Differential backups on weekdays, Full on
sundays & filenames with timestamp info
http://www.umachandar.com/technical...ipts/Main30.htm
as Tibor said you can schedule this script by SQL Agent.
HTH
Regards
THIRUMAL REDDY MARAM
Sys Admin/ SQL Server DBA

quote:

---

>--Original Message--
>Maint plans doesn't support diff backups. Db Maint does

---

(www.dbmaint.com),

quote:

---

>or write your own TSQL command and schedule them using

---

Agent, quite simply

quote:

---

>:-).
>--
>Tibor Karaszi, SQL Server MVP
>Archive at:
>http://groups.google.com/groups?

---

oi=djq&as_ugroup=microsoft.public.sqlserver

quote:

---

>
>"keremcan" <kbuyuktaskin@.yahoo.com> wrote in message
>news:2da501c3e183$8843dca0$a401280a@.phx.gbl...
Plan,[QUOTE]
there a[QUOTE]
backup[QUOTE]
below:[QUOTE]
>
>.
>

---