Post reply

sql server 2008 backups of transaction logs taking longer and longer

  • July 11, 2012 at 6:19 pm

    #263685

    I'm fairly new to sql server 2008 and didn't have this problem in sql server 2005. My databases are in full recovery model. I'm taking a transaction log backup every hour. The transaction Log backups seems to take longer and longer as the day goes on. I also take full and diff backups. Not sure why the transaction log backups take so long.

    Thanks in advance!

  • July 11, 2012 at 10:14 pm

    #1511856

    What does the following query return while the log files get bigger?

    select

    [name] as DatabaseName,

    log_reuse_wait_desc

    from

    sys.databases;

  • July 12, 2012 at 3:16 am

    #1511930

    What's the script you use to take log backups.

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply