Posted by gabe101 on 12/19/06 17:57

Erland Sommarskog wrote:
>
> No, there is no such setting. I don't really know when 12.00 pm is, but
> I guess it's at noon, since it causes problems.

Thank you and yes, you are correct...it's noon.

> It may be a better to idea to schedule the full backup for off-hours,
> and only take log backups during the day.

We currently do a full back up every night and no log back-ups. We're
on 'Simple' recovery model and plan to just restore to the most recent
full backup during a crisis. We can afford this "luxury" because we're
a small office with few transactions during the work day. This is why
I chose to do one more live backup of our company database at the noon
hour...cutting potential losses by 50% (the small losses that they
would be).

> Then again, a full backup slowing the server to a crawl, does not seem
> normal to me. Could be that your hardware is a bit thin. Do you take
> the backup to local disk or a network drive?

We have a good server but it's our only server (Dual Xeon 3.0, 4GB RAM
and 4, 10K RPM RAID-5 drives). Originally, it was just SQL Server and
Symantec AV...now it's also Exchange. The backup is being stored to
the Data partition on that same server's RAID drives.

Thanks Erland.

[Back to original message]