Differntial Backup doesn't work

I setup Differntial Backup through EM but it doesn't
work. The backup file added up 1G in every back up and
end up with running out of space.
Can anybody tell me what's wrong?
Frankprobably you are adding backup into existing backup over and over, causing
it increases until no more empty sapce. You need to review your backup
strategy.
"Frank Jiang" <frank@.discussions.microsoft.com> wrote in message
news:2b6401c3e1d6$bbf8c6c0$a301280a@.phx.gbl...

quote:

---

> I setup Differntial Backup through EM but it doesn't
> work. The backup file added up 1G in every back up and
> end up with running out of space.
> Can anybody tell me what's wrong?
> Frank

---

|||I do a complete backup once eveyday and differential
backup every 20 minutes, append to media.
I check all the setting of the differential backup in
Enterprise Manager and didn't find anything wrong.
Frank

quote:

---

>--Original Message--
>probably you are adding backup into existing backup over

---

and over, causing

quote:

---

>it increases until no more empty sapce. You need to

---

review your backup

quote:

---

>strategy.
>"Frank Jiang" <frank@.discussions.microsoft.com> wrote in

---

message

quote:

---

>news:2b6401c3e1d6$bbf8c6c0$a301280a@.phx.gbl...
>
>.
>

---

|||with differential backup you don't have the option to restore DB to a
certain time.
Can you do differential backup every 4 hrs and do log backup every 20
minutes to a separate backup device? It may help.
"Frank J" <frank@.discussions.microsoft.com> wrote in message
news:330801c3e1da$b4ee92c0$a501280a@.phx.gbl...[QUOTE]
> I do a complete backup once eveyday and differential
> backup every 20 minutes, append to media.
> I check all the setting of the differential backup in
> Enterprise Manager and didn't find anything wrong.
> Frank
>
> and over, causing
> review your backup
> message|||It never happened so far that we need to restore DB. But
theoretically, we can resote DB from a complete backup
and on top of that we do recover from differential
backup. Thats why we do a complete backup everyday and
followed by 20 minutes differential backup.
Transaction log is huge and should we backup it?
Frank

quote:

---

>--Original Message--
>with differential backup you don't have the option to

---

restore DB to a

quote:

---

>certain time.
>Can you do differential backup every 4 hrs and do log

---

backup every 20

quote:

---

>minutes to a separate backup device? It may help.
>
>"Frank J" <frank@.discussions.microsoft.com> wrote in

---

message

quote:

---

>news:330801c3e1da$b4ee92c0$a501280a@.phx.gbl...
over[QUOTE]
in[QUOTE]
and[QUOTE]
>
>.
>

---

|||from BOL: A differential backup creates a copy of all the pages in a
database modified after the last database backup.
so to restore you just need a full backup and the last differential backup.
You keep adding differential backup into same backup device every 20 minutes
then no wonder it keeps growing 'til you are out of space.

quote:

---

> Transaction log is huge and should we backup it?

---

depend on your needs. I always backup the log.
"Frank J" <anonymous@.discussions.microsoft.com> wrote in message
news:2cbc01c3e1e7$7aef6470$a101280a@.phx.gbl...[QUOTE]
> It never happened so far that we need to restore DB. But
> theoretically, we can resote DB from a complete backup
> and on top of that we do recover from differential
> backup. Thats why we do a complete backup everyday and
> followed by 20 minutes differential backup.
> Transaction log is huge and should we backup it?
> Frank
>
> restore DB to a
> backup every 20
> message
> over
> in
> and