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 |
|
SQL360
Starting Member
20 Posts |
 Posted - 2008-11-04 : 17:40:42
|
| One of the transaction log backup is taking way long than it usually does.It usually takes 20 seconds every four hours to do the same transaction log backup on this database but over the weekend it took 9 hours. The log file is about 68 MB only.I have checked the logs on maintenance plan, job history on sql 2000 side and checked all logs under event viewer on windows side but still not able to pinpoint the cause.Any help where I may be able to check more to find out root cause would be helpful. Thank you.SQL360 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2008-11-04 : 18:12:56
|
| Did you have some maintenance run like a DBCC DBREINDEX?---------------------------EmeraldCityDomains.com |
 |
|
|
SQL360
Starting Member
20 Posts |
Posted - 2008-11-05 : 11:44:18
|
| I do have dbcc checkdb integrity including indexes running via maintainance plan but this has always been the case though? Thank you.SQL360 |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-05 : 11:49:33
|
| See the job history for how long it ran? |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2008-11-06 : 12:49:25
|
| Well, that is an outrageous expansion (20 seconds to 9 hours). Rebuilding indexes and activity like that will cause your next LOG backup to be larger and longer because it is including all that work that was done. But unless that was the first time, and you normally don't do anything on this DB, and there are a LOT of indexes and Data, that probably does not account for this much difference. . Often when something runs abnormally long in our systems I have found that there was blocking going on, but off the top of my head I can't think of what would block a backup.Has this happened again or just the one time?---------------------------EmeraldCityDomains.com |
|
|
|
|
|
|
Transaction Log Backup