| Author |
Topic |
|
fruitbat04
Starting Member
6 Posts |
 Posted - 2007-03-29 : 13:03:48
|
| Hi there,I've got a database of about 400GB that used to take 5 hours to backup through the scheduler in MS SQL Enterprise manager. One day, it just jumped about to 20 hours, even though no system changes were made that I'm aware. It still completes OK, and I can't find anything obvious errors in the event log, but this is causing a problem in that I'm being pressed for system upgrades which I don't want to do if a restore is going to take a whole day. I've asked our resident DBA to have a look, but he hasn't come back with anything.Anyone know any possible causes? This is within a SQL 2000 enterprise Clustered 2003 server environment (problem occurs on both nodes) Quad Xeon 3.2 ghz/8gb RAM |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-03-29 : 13:27:53
|
| Maybe it was time for some retention overwrites?Peter LarssonHelsingborg, Sweden |
 |
|
|
sql_er
Constraint Violating Yak Guru
267 Posts |
Posted - 2007-03-29 : 18:46:50
|
| Check your table growth:http://vyaskn.tripod.com/code/sp_show_huge_tables.txt |
|
|
|
chetan06
Starting Member
11 Posts |
Posted - 2007-03-30 : 01:26:54
|
| Hi,This query for checking table growth is very useful...Cjain |
|
|
|
craig79
Starting Member
33 Posts |
Posted - 2007-04-18 : 06:33:33
|
| Is it a network Backup or LocalBackup.. If on Network then even ur network speed needs to be considered. |
|
|
|
devmathur
Starting Member
3 Posts |
Posted - 2007-04-19 : 16:07:18
|
| I am facing the same problem.Time taken in backup is increasing drmatically.While same size Databases on the other server is taking less time.Just for a thought "Does it depend on accessing the local drives bcoz currently we are facing problem in accessing that drives?" |
|
|
|
fruitbat04
Starting Member
6 Posts |
Posted - 2007-04-20 : 19:10:19
|
| Just as an update on this,The problem is not resolved yet, however as a test I put a 640GB USB2 drive and attached it to the server. It backed up far quicker than on the Powervault 220, so I believe this is a hardware issue. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-20 : 23:57:36
|
| Tried update the driver? I fixed similar disk speed issue by updating driver. |
|
|
|
fruitbat04
Starting Member
6 Posts |
Posted - 2007-04-21 : 18:30:27
|
| Yeah, that is the standard reply from Dell as well even though it has been working fine on the current drivers. Next time I can get some down time that is what I'm going to try. |
|
|
|
|
Backup time has increased drastically!