Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mpreissner
Starting Member
21 Posts |
 Posted - 2011-02-24 : 09:17:53
|
| I'm managing a SQL 2005 database that holds CDR data for a large telecomm project. My database is currently about 120 GB and backups are taking FOREVER (to the tune of 8 hours+). We are using NeverFail to handle replication/failover.The hardware is a little on the slow side in my opionion, running 3x 15k drives in a RAID 5 config (not my choice). To compare, another database I manage is successfully backing up 145 GB in 40 minutes, with little difference in the hardware.Can anyone help me figure out what is slowing down the backups so much? CPU and memory utilization are well within a tolerable range (CPU rarely goes over 20%, mem is about 75%). Thanks in advance! |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2011-02-24 : 09:51:58
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=157432 |
 |
|
|
|
|
|
Big backup problem