Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    12

    Lightbulb Unanswered: Food for thought (ReIndex and Log shipping)

    I have a production 60GB database set to Full Recovery and every 15 minutes I am log shipping to a Stand by Server .

    During the production hours there are no problems but at night when I run DBCC DBREINDEX, the log grows to 22GB and because of this I have a problem sending this over the network to the stand by server.

    I tried changing the recovery model to Bulk_Logged but the there is no difference in log file backup size.

    AnyIdea

  2. #2
    Join Date
    Dec 2003
    Posts
    12

    Do I need to live with this?

    Any comments?

Posting Permissions

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