Database backup

In EM, I can only configure Database Maintenance Plan by full backup and
transaction log.
How do I set differential/incremental backup ?Differential database backups are not implemented in Database Maintenance
Plan. You will have to create your own jobs using the BACKUP and RESTORE
commands. More information about these commands and lots of examples are
available in SQL Server Books Online.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:umvDl9BWEHA.1380@.TK2MSFTNGP12.phx.gbl...
In EM, I can only configure Database Maintenance Plan by full backup and
transaction log.
How do I set differential/incremental backup ?|||Hi,
I hope that you can only do FULL and Transaction Log backups by the
maintenance plan.
But you can generate a SQL job to do this. Just right click on the database
in the EM, Select the database, All tasks, backup databse, choose
differential backup, and then choose "Schedule" where you can
make it as a recurring schedule.
--
Thanks
Hari
MCDBA
"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:umvDl9BWEHA.1380@.TK2MSFTNGP12.phx.gbl...
> In EM, I can only configure Database Maintenance Plan by full backup and
> transaction log.
> How do I set differential/incremental backup ?
>