Thursday, January 12, 2012 6:40 PM
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?
Thursday, January 12, 2012 6:45 PM
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
Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.
Thursday, January 12, 2012 6:53 PM
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.
- Proposed As Answer by RamJaddu Thursday, January 12, 2012 9:13 PM
Thursday, January 12, 2012 9:15 PMDB Mirroring configured on full recovery model which supports bulk inserts with out any doubt ......