Database Backups

can I get someones opinion of full backups? I currently have full backups 3
days a w and t-logs every hour. I was thinking about switching to full
bakcups every day. Is there a problem with this strategy?Depends on your database size, available disk space, etc.
All of my clients are currently doing at least one full backup a day, some
more...:-) Most of them have database sizes under 20GB.
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Lontae Jones" <LontaeJones@.discussions.microsoft.com> wrote in message
news:15C5AC5A-A72A-4C5A-A5A4-63A5EE948575@.microsoft.com...
> can I get someones opinion of full backups? I currently have full backups
> 3
> days a w and t-logs every hour. I was thinking about switching to full
> bakcups every day. Is there a problem with this strategy?|||There is no problem with the new strategy if the off-peak duration of your
database is more than the time taken by full database backup. Let ms explain
with an example: Suppose Full Backup of the database takes 2 hours, and only
a few user activites happen in the database from 00:00 Hours to 04:00 Hours.
Thus scheduling a Full Backup every day is a very good decision.
"Lontae Jones" wrote:

> can I get someones opinion of full backups? I currently have full backups
3
> days a w and t-logs every hour. I was thinking about switching to full
> bakcups every day. Is there a problem with this strategy?|||Thanks for all replies.
My disk space is 100 Gb and my fullbackups would be 91.GB. ALso what if I
lose a backup or something happens then I dont have logs right?
"Kevin3NF" wrote:

> Depends on your database size, available disk space, etc.
> All of my clients are currently doing at least one full backup a day, some
> more...:-) Most of them have database sizes under 20GB.
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
>
> "Lontae Jones" <LontaeJones@.discussions.microsoft.com> wrote in message
> news:15C5AC5A-A72A-4C5A-A5A4-63A5EE948575@.microsoft.com...
>
>|||You have logs if you are in Full Recovery mode, and you need to be backing
them up. If you are in simple recovery mode, your recoverability is limited
to the point of the last full backup.
With data size and space as you mention, you might want to look into a
backup compression utility such as SQL LiteSpeed (I'm a reseller) or SQLSafe
(no affiliation)...you can get anywhere form 50-90% compression and time
reduction using these.
HTH,
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Lontae Jones" <LontaeJones@.discussions.microsoft.com> wrote in message
news:860DF5D5-9731-4D1F-A934-78A6EEA84555@.microsoft.com...
> Thanks for all replies.
> My disk space is 100 Gb and my fullbackups would be 91.GB. ALso what if I
> lose a backup or something happens then I dont have logs right?
> "Kevin3NF" wrote:
>