Home Forums SQL Server 2005 Administering Truncate log for Mirrored Database RE: Truncate log for Mirrored Database

  • October 20, 2008 at 7:50 pm

    #887395

    GilaMonster (10/20/2008)

    rishgup (10/20/2008)

    I have scedule transaction log back every weekend. nut still no use. Trans log file is growing day by day.

    You need to backup the log a lot more than once a week. Depending on activity, once or twice an hour.

    How often are you backing up the log? Is you query the sys.databases view, what does the column log_reuse_wait_desc show for the DB in question?

    Now I setup Transaction log back up every 2 hours and the log_reuse_wait_desc for database is LOG_BACKUP