Does mirroring not capturing bulk insert executions?

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

Answer 1

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.

Answer 2

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.

Answer 3

DB Mirroring configured on full recovery model which supports bulk inserts with out any doubt ...... 

---

http://uk.linkedin.com/in/ramjaddu