Differntial Backups

Hi,
I wrote a script that theoretically does the following:
Does a weekly full backup to a file
Does a nightly differential backup to a file
Does hourly transaction logs to a seperate file per hour.
As I understand it, the differential is supposed to be based off of the full
backup. After the first nightly, is each differential still based off of
the original full back up? or is it based of the previous nights
differential, which means I'd have to keep each daily differential until the
week cycled
Thanks,
GaryA diff backup is always based on the latest full backup. This is why you do
the restore like: latest full backup, *latest* diff backup and each
subsequent log backups.
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Gary" <n> wrote in message news:%23mUwyzp6DHA.1556@.tk2msftngp13.phx.gbl...

quote:

---

> Hi,
> I wrote a script that theoretically does the following:
> Does a weekly full backup to a file
> Does a nightly differential backup to a file
> Does hourly transaction logs to a seperate file per hour.
> As I understand it, the differential is supposed to be based off of the

---

full

quote:

---

> backup. After the first nightly, is each differential still based off of
> the original full back up? or is it based of the previous nights
> differential, which means I'd have to keep each daily differential until

---

the

quote:

---

> week cycled
> Thanks,
> Gary
>

---

|||Thanks.
I was pretty sure that's how it worked, I just wanted a second opinion
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%231UIe4p6DHA.3648@.TK2MSFTNGP11.phx.gbl...

quote:

---

> A diff backup is always based on the latest full backup. This is why you

---

do

quote:

---

> the restore like: latest full backup, *latest* diff backup and each
> subsequent log backups.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
>

---

http://groups.google.com/groups?oi=...ublic.sqlserver

quote:

---

>
> "Gary" <n> wrote in message

---

news:%23mUwyzp6DHA.1556@.tk2msftngp13.phx.gbl...

quote:

---

> full
of[QUOTE]
> the
>

---