Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    Canada
    Posts
    16

    Unanswered: High Availability with Log Shipping

    I have implemented log shipping between 2 databases, the transaction log size normally between 10mb - 50mb every 15 minutes during normal working hours, but it grows to 9GB when we run database optimization job and that makes it hard and long to transfer and apply the transaction log on the other database. Does anybody encountered a situation like this and is there a way to minimize the size of the Trans log after the optimization job?

    Thanx

  2. #2
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Exclamation High Availability with Log Shipping

    Use the shrink command: You can look it up. It allow for a backup of the log then it's shrunk to the specified size. Please look up on Book on line or ms sql server support. I suggest shrinking before the other processes.

    BACKUP LOG wslogdb62 WITH TRUNCATE_ONLY
    DBCC SHRINKFILE('wslogdb62_log.ldf', 1)

Posting Permissions

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