hi,
Is it possible to to do an incremental update through DTS ?
The database tables do not have a time stamp.

My problem
We have a production database wchich is backed up every night.
What we need is an incremental backup everyday in addition to the full backup.
How can I do this? Was thinking of using DTS for incremental with somehow
telling it to backup since a particular date.
All comments welcome

Incremental backup?

Have you looked at Differential Backups. These take ALL changes since the
last FULL backup

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Tarak" <Tarak (AT) discussions (DOT) microsoft.com> wrote

Thanks Allan,
I meant differential update when I said incremental, sorry about that.

The problem is if I take a differential backup and then a nighly full backup
the differential backup nextday will start from the full backup point and not
from the diffeentiial backup, let me know if I am wrong on this.
Thanks again.

Tarak

"Allan Mitchell" wrote:

No you are perfectly correct on this point.

The advantage of Diffs is that it reduces the amount of backups you
potentially have to restore.

You could look at log backups / log shipping.

We could do something in DTS but it will be more protracted

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Tarak" <Tarak (AT) discussions (DOT) microsoft.com> wrote