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

backup types

hi
Can any one recomend what is difference between
differential and incremental backup in SQL Server 2000.
Thanks
Kalyan
There 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

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

Backup to disk

I am setting up my backup strategy and want to do Full backups at night
(12:00 am) and hourly incremental backups to disk.
The problem is the incrementals just keep getting appended to the same data
file *.bak.
If I find that our data is corrupted after about 2:00 pm and want to
restore, I would need to restore the up until 1 PM.
I would need to restore the Full backup and 13 differentials (not all the
differentials).
How do I do that if they are all in the same file?
Thanks,
Tom
You just use the FILE = parameter in your RESTORE command.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
"tshad" <tscheiderich@.ftsolutions.com> wrote in message
news:eohyDNy5FHA.252@.TK2MSFTNGP15.phx.gbl...
>I am setting up my backup strategy and want to do Full backups at night
>(12:00 am) and hourly incremental backups to disk.
> The problem is the incrementals just keep getting appended to the same
> data file *.bak.
> If I find that our data is corrupted after about 2:00 pm and want to
> restore, I would need to restore the up until 1 PM.
> I would need to restore the Full backup and 13 differentials (not all the
> differentials).
> How do I do that if they are all in the same file?
> Thanks,
> Tom
>

Backup to disk

I am setting up my backup strategy and want to do Full backups at night
(12:00 am) and hourly incremental backups to disk.
The problem is the incrementals just keep getting appended to the same data
file *.bak.
If I find that our data is corrupted after about 2:00 pm and want to
restore, I would need to restore the up until 1 PM.
I would need to restore the Full backup and 13 differentials (not all the
differentials).
How do I do that if they are all in the same file?
Thanks,
TomYou just use the FILE = parameter in your RESTORE command.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
"tshad" <tscheiderich@.ftsolutions.com> wrote in message
news:eohyDNy5FHA.252@.TK2MSFTNGP15.phx.gbl...
>I am setting up my backup strategy and want to do Full backups at night
>(12:00 am) and hourly incremental backups to disk.
> The problem is the incrementals just keep getting appended to the same
> data file *.bak.
> If I find that our data is corrupted after about 2:00 pm and want to
> restore, I would need to restore the up until 1 PM.
> I would need to restore the Full backup and 13 differentials (not all the
> differentials).
> How do I do that if they are all in the same file?
> Thanks,
> Tom
>

Backup to disk

I am setting up my backup strategy and want to do Full backups at night
(12:00 am) and hourly incremental backups to disk.
The problem is the incrementals just keep getting appended to the same data
file *.bak.
If I find that our data is corrupted after about 2:00 pm and want to
restore, I would need to restore the up until 1 PM.
I would need to restore the Full backup and 13 differentials (not all the
differentials).
How do I do that if they are all in the same file?
Thanks,
TomYou just use the FILE = parameter in your RESTORE command.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
"tshad" <tscheiderich@.ftsolutions.com> wrote in message
news:eohyDNy5FHA.252@.TK2MSFTNGP15.phx.gbl...
>I am setting up my backup strategy and want to do Full backups at night
>(12:00 am) and hourly incremental backups to disk.
> The problem is the incrementals just keep getting appended to the same
> data file *.bak.
> If I find that our data is corrupted after about 2:00 pm and want to
> restore, I would need to restore the up until 1 PM.
> I would need to restore the Full backup and 13 differentials (not all the
> differentials).
> How do I do that if they are all in the same file?
> Thanks,
> Tom
>