I manage a SQL 05 ent database for a user here and they decided its
important enough to be backup up every hour. I was wondering what the best
way to approach this was?

they don't care so much about point in time restores, mostly they just want
to make sure their is no data lose.

I had considered doing a full backup at night, and then everyone hour, for 3
hours, do an incremental backup and then every 4 hours a differential backup
and toss out the old inc's.

Sounds like it would work well, just have no idea on how to implement this
correctly.

any advice?

Thanks
Justin

By incremental do you mean Log backup? Why do it every hour? If they are
concerned with minimizing data loss then make them more frequent. I suggest
no more than every 15 minutes if not more frequent. Your potential for loss
is the frequency of the log files in the event of a total meltdown where you
can not recover the existing data and log files.

--
Andrew J. Kelly SQL MVP

"Justin Rich" <jrich523@yahoo.com.spam> wrote in message
news:%23jEMHlwwHHA.2488@TK2MSFTNGP03.phx.gbl...
>I manage a SQL 05 ent database for a user here and they decided its
>important enough to be backup up every hour. I was wondering what the best
>way to approach this was?
>
> they don't care so much about point in time restores, mostly they just
> want to make sure their is no data lose.
>
> I had considered doing a full backup at night, and then everyone hour, for
> 3 hours, do an incremental backup and then every 4 hours a differential
> backup and toss out the old inc's.
>
> Sounds like it would work well, just have no idea on how to implement this
> correctly.
>
> any advice?
>
> Thanks
> Justin
>