locked
Does mirroring not capturing bulk insert executions? RRS feed

  • Question

  • My manager has expressed concern over mirroring not capturing bulk insert executions.  Does anyone have any idea on whether or not that will work?  His thought is that we might need to change from simple logging to full?

    Any thoughts from anyone?

     


    lcerni
    Thursday, January 12, 2012 6:40 PM

Answers

  • Icerni,

     

    Per MSDN http://msdn.microsoft.com/en-us/library/ms189852.aspx

    Mirroring is implemented on a per-database basis and works only with databases that use the full recovery model. The simple and bulk-logged recovery models do not support database mirroring

     


    Thanks
    Manish

    Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.
    • Proposed as answer by RamJaddu Thursday, January 12, 2012 9:13 PM
    • Marked as answer by lcerni Friday, January 13, 2012 3:31 PM
    Thursday, January 12, 2012 6:45 PM

All replies

  • Icerni,

     

    Per MSDN http://msdn.microsoft.com/en-us/library/ms189852.aspx

    Mirroring is implemented on a per-database basis and works only with databases that use the full recovery model. The simple and bulk-logged recovery models do not support database mirroring

     


    Thanks
    Manish

    Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.
    • Proposed as answer by RamJaddu Thursday, January 12, 2012 9:13 PM
    • Marked as answer by lcerni Friday, January 13, 2012 3:31 PM
    Thursday, January 12, 2012 6:45 PM
  • Hello,

    First of all Mirroring will work only on Full Recovery model.I am surprised how you configured mirroring on Simple recovery and tested bulk insert.

    Mirroring will support bulk inserts for sure.

    Thank you,

     


    Anup | Database Consultant

    Blog: www.sqlsailor.com Twitter: Follow me !

    Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    • Proposed as answer by RamJaddu Thursday, January 12, 2012 9:13 PM
    Thursday, January 12, 2012 6:53 PM
  • DB Mirroring configured on full recovery model which supports bulk inserts with out any doubt ...... 
    http://uk.linkedin.com/in/ramjaddu
    Thursday, January 12, 2012 9:15 PM