Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    2

    Unanswered: SQL Server Transaction Log backup hanging

    I created a db maintenance plan to backup 5 databases, (tranaction log backups) and it was working fine until a couple of days ago when I noticed that the job would still be running the next morning, and I have cancel it or reboot the server.

    The job backed up 4 of the databases but just hangs while backing up the 5th. I can perform a transaction log backup via EM fine.

    When I reboot the server it works fine for half a day and the same thing happens again.

    There are no error messages in job history because I cancelled it. There
    are no errors in the sql log. There are no errors in Windows event
    viewer.

    I ran DBCC with no errors

    Any ideas?

    Thanks

  2. #2
    Join Date
    May 2003
    Location
    UK
    Posts
    220
    Howdy

    (1) Do you have enough disk space?
    (20 Are you on the lastest Service Pack? I have heard of this as a SQL memory leak problem which is fixed by SP update.

    Cheers

    SG

  3. #3
    Join Date
    Oct 2003
    Posts
    2

    Thumbs up

    Thanks for your help, the matter has been resolved

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •