SQL Server Performance

Transaction Log Backup

Discussion in 'SQL Server Clustering' started by franco, Oct 12, 2006.

  1. franco New Member

    Hi all,
    We have many databases to manage and my question is related to T-Log backup.
    At the moment we take t-log backup every 1 hour but on different time for each database.

    For exaample for db1 we take t-log backup at 7.01 AM every hour until 19.01 PM and for db2 we take backup at 7.05 AM until 19.05 PM and so on.

    Is it ok to perform t-log backup for all the databses at the same time or is it better to perform it on different time like now?

    Our system is a 2 node MSCS Cluster with SQL Server 2K Enterprise Edition, 8 GB RAM and 4 CPU for each node.
    SQL Server has a dedicated memory of 2GB.

    Please advise.


  2. thomas New Member

    It is better to spread them out. If you do them all at the same time they'll all compete for I/O, both on the transaction log partition and whereever you're backing them up to.
  3. franco New Member

    Thank you very much for your suggestion.

  4. satya Moderator

    What is the log growth within every hour on those 2 databases?
    If it is nothing much say not more than 300 k then you can run both at a time, if the databases are used frequently then in order to avoid slow performance during the process of writing the backup to file you can keep a 10 mins interval on Tlog backup.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    This posting is provided AS IS with no rights for the sake of knowledge sharing.

Share This Page