|
|
Posted by Erland Sommarskog on 12/13/06 22:55
gabe101 (gabe101@gmail.com) writes:
> I've searched enough to know that this ability probably doesn't exist
> in our current setup, thus the reason I'm coming to the community now.
> When doing a database backup in Enterprise Manager (SQL Server 2000
> sp4), is there a priority level setting so that I can put less load on
> the CPU? Our small office uses one server for everything and when I do
> a 12:00 pm full backup of our live DB, the server slows to a crawl for
> about 4 or 5 minutes. I'd like to see the backup take longer but put
> less load on the server so we can to use it. If this setting doesn't
> exist, I may need to explore another backup method...but that's another
> topic for another day.
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.
It may be a better to idea to schedule the full backup for off-hours,
and only take log backups during the day.
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?
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|