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 |
|
pdset
Constraint Violating Yak Guru
310 Posts |
 Posted - 2014-02-16 : 18:14:35
|
| We are running 2- instances where one being 2005 and other 2008 R2 and we run Full Backups every night and the time slot is recorded consistent.But on otherday it has consumed more time around 30- 45 Minutes more and I have investigated through Errorlog but have no entry into that.if the time has increased along with the DB size then it is normal, but only on particular days it is recorded with higher time being consumed for the overall backup.There is no significant increase in the Data file size of any database picked up for the backup, but this is occurring with more time only on selected days where there is no other activity registered.Is there any way that I can monitor (if not from TRACE)what could cause the Backup time being increased only for those days which are more (otherwise the following day the backup times would be normal recording).Please advise and thanks. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2014-02-17 : 01:49:51
|
| Are you backing up to tape or disk?Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2014-02-17 : 23:12:56
|
| Disk Only not to Tape. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
|
|
|
|
Backup Times Abnormal