Monday, February 13, 2012

backup types

hi
Can any one recomend what is difference between
differential and incremental backup in SQL Server 2000.
Thanks
KalyanThere is no difference. There is no such thing in SQL Server as an
Incremental backup command just Differential. People use the terms as one
all the time though.
Andrew J. Kelly SQL MVP
"Kalyan" <Kalyan@.discussions.microsoft.com> wrote in message
news:7ACE845D-46D1-4374-B273-C2B30589BC31@.microsoft.com...
> hi
> Can any one recomend what is difference between
> differential and incremental backup in SQL Server 2000.
> Thanks
> Kalyan|||There isn't an "incremental" backup in SQL. However, if you are familiar
with NT backup. The term differential backup in SQL is equal to incremental
backup in NT. It backs up the changes since the last full backup.
"Kalyan" wrote:

> hi
> Can any one recomend what is difference between
> differential and incremental backup in SQL Server 2000.
> Thanks
> Kalyan

No comments:

Post a Comment