November 4, 2008 at 3:56 pm
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 and checked all logs under event viewer on windows 2000 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.
November 4, 2008 at 5:48 pm
SQL 2000 or SQL 2005? This is a SQL 2005 forum.
If SQL 2000, was there a full or diff database backup occurring at that time?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 7, 2008 at 8:34 am
Stop and restart the job. Make sure that Full and or Diff backup jobs are not running while you are attempting to run this transaction log backup job..
Thansk!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 10, 2008 at 8:50 am
Autoshrink enabled?
Wilfred
The best things in life are the simple things
November 10, 2008 at 12:01 pm
either something else was running or you had a conflict.
Are you backing up to new files all the time? Could have corrupted a file and that might stick the backup for awhile as it tries to work around.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply