river1 (12/6/2010)
1) I will put some apps that i have, in mirror, but this apps use Bulk operations to import data at the end of the day. In mirror, can i use minimal log for bulk operations (put the recovery model as Bulk-logged)?
No. Mirroring requires full recovery model.
2) I know what are checkpoint, but in your archicle you talk about lazy writes. What are lazy writes?´
Is google broken?
http://sqlinthewild.co.za/index.php/2009/06/26/the-lazy-writer-and-the-checkpoint/
3) You told in your archicle that you would not talk about how mirroring afects the log. Do you have any archicle with that information?
No, I don't do enough with mirroring to be able to.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability