Post reply

Is Database shrinkage possible in Replication ?

  • May 4, 2010 at 12:18 am

    #224100

    Is Database shrinkage possible in Replication ?

  • May 4, 2010 at 12:26 am

    #1161616

    Do you mean is it possible to shrink the database files using the DBCC SHRINKFILE or DBCC SHRINKDATABASE commands? Yes it is possible. In general shrinking databases is not a good idea, whether replicated or not. Do it only for exceptional reasons and don't do it regularly.

  • May 4, 2010 at 12:37 am

    #1161617

    Thanks David,

    one more assist you have specified - [ Do it only for exceptional reasons ]

    Can you specify the exceptional reasons or if anybody has faced such situation.

    I need to know for my knowledge purpose.

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

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