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 |
|
laddu
Constraint Violating Yak Guru
332 Posts |
 Posted - 2007-11-30 : 20:25:01
|
| Full backup job of one user database(10.8 GB) is taking abnormally long time 9 hrsPlease let me know where can I start investigating on this ?laddu |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-11-30 : 21:36:18
|
how big is it? I have a 1TB db that takes about 2 hours to backup...
elsasoft.org |
 |
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2007-11-30 : 21:43:26
|
| 10.8 GB |
|
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2007-11-30 : 21:51:21
|
| I am backing up to disk. I am taking the Full backup .Database size is 10.8 GB. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-02 : 00:00:31
|
| Where is the disk? What kind of disk? Is it single disk or disk array? |
|
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2007-12-02 : 01:20:36
|
| It's a single diskI monitored the job...today it took 3 hrsI did't find anything in logsplease advice |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-02 : 01:30:36
|
| It depends on disk type and speed, pci disk usually is slower than scsi ones. And monitor disk i/o in perfmon. |
|
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2007-12-03 : 03:12:49
|
| I monitored the job ...last run took 1 hr 21 minThen 3 days ago why the job was ran abnormally 9 hrs?? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-03 : 23:00:14
|
| Can't tell since don't know your disk's i/o. |
|
|
|
|
|
|
Backup job