locked
Database Mirorring RRS feed

  • Question


  • Hi Everybody,


    if my principal server is in autoshink true.. can i do a database miroring .. does the mirroring works fine.....??


    Thanks
    subu
    Monday, July 14, 2008 11:12 AM

Answers

  • Generally its not advisable to turn on autoshrink as it affects the performance. So, its better that you configure mirroring with that option being disabled..I haven't tested mirroring with autoshrink enabled. But since it is a database property I think it will still work.

     

    - Deepak

    Monday, July 14, 2008 12:58 PM

All replies

  • Generally its not advisable to turn on autoshrink as it affects the performance. So, its better that you configure mirroring with that option being disabled..I haven't tested mirroring with autoshrink enabled. But since it is a database property I think it will still work.

     

    - Deepak

    Monday, July 14, 2008 12:58 PM
  • Yes there is no affect on  Mirroring , But Auto-Shrink is not a recommended configuration.

    Thursday, July 17, 2008 9:40 AM
  •  

    Concur...It will work, however, Autoshrink is not recommended on production databases as performance and defragmentation occurs!!!
    Thursday, July 24, 2008 12:34 AM
  • mirror will work even if you put true flag for shrink. But as per other's suggesion it is not advicable, instead you can

    create seperate maintenance plan for shrinking database during week end or non-working application time.

    It is better to keep maintaining your database performance.

    kumar

    Friday, August 1, 2008 6:10 PM