Visual studio feeds

All Visual Studio blogs in one place


Enter your email address:

Delivered by FeedBurner

Increase your website traffic with



Anti-spam: How many eyes has a typical person?

Follow us on FB


Minimal Logging in FULL recovery mode

AddThis Social Bookmark Button
As per BOL ( here and here),  minimal logging is only possible in SIMPLE and BULK-LOGGED recovery mode using bulk operations  and FULL recovery mode fully logs all transactions. But, I have seen that the minimal logging is happening for when we load data into tables using SSIS, for some combination minimal logging is happening even if database in FULL  recovery mode. Below is the create to create such database and source table. use master go if db_id('minimalLogTest') is not null begin alter database minimalLogTest set single_user with rollback immediate drop database
minimalLogTest end go Create database minimalLogTest go Alter database minimalLogTest set recovery FULL go use minimalLogTest go if object_id('sourceTable') is not null drop table sourceTable go Create table sourceTable ( id int identity(1,1), name nvarchar(10) default 'abc', dateOfbirth date default '20000101' ) go --now insert 1000000 rows into source table declare @i int = 0 Set nocount on; begin transaction while ( @i < 1000000) begin insert into sourceTable default values ...(Read whole news on source site)

Home : Blog List : Chintak's Blog : Minimal Logging in FULL recovery mode