asked
minimally logged
how sql engine work in time of minimally logged. or explain how to transaction logged in bulk logged recovery model.
http://msdn.microsoft.com/en-us/library/ms190692%28v=sql.105%29.aspx Has a section on how the bulk logged recovery model works
as per the BOl "bulk logging operations prevents recapturing changes on a transaction-by-transaction basis" I think it means sql engine logged records after completing the who bcp operation. iind question what happen if my bcp operation showing error message. please advise me step after bcp operation showing error.
The engine works the same and individual transactions aren't logged but the altered pages are. This allows for greater throughput but less granualar recovery.
13 People are following this question.
