October 14, 2008 at 1:50 pm
Can you explain more to me about Bulk-Logged model, can't understand in what point is better to use it. Thank you
October 14, 2008 at 4:44 pm
The Bulk-Logged model provides higher performance and lower log space consumption for certain large-scale operations (for example, create index or bulk copy). It does this at the expense of some flexibility of point-in-time recovery. Its best ot use when you are performing bulk loads and index creation like huge log consuming operations.
These operations are minimally logged:
SELECT INTO.
Bulk load operations (bcp and BULK INSERT).
CREATE INDEX (including indexed views).
text and image operations (WRITETEXT and UPDATETEXT).
Microsoft recommends that the bulk-logged recovery model only be used for short periods of time. Best practice dictates that you switch a database to the bulk-logged recovery model immediately before conducting bulk operations and restore it to the full recovery model when those operations complete.
MJ
October 15, 2008 at 12:39 am
See this excellent article about recovery models: http://www.sql-server-performance.com/articles/per/Database_Recovery_Models_in_SQL_Server_p1.aspx
Wilfred
The best things in life are the simple things
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply