SQL Server Storage Engine : New update on minimal logging for SQL Server 2008

SQL Server Storage Engine

New update on minimal logging for SQL Server 2008

Based on the customer feedback, we have decided to make minimal logging functionality into a btree available to SQL 2008 customers. All you need to do is to enable TF-610 in RTM bits. As a cautionary note, we have seen some slowdown if you are loading data into a btrree using TF-610 on a slower IO subsystem. So please make sure you test it first.

For details, please refer to my blog entries

http://blogs.msdn.com/sqlserverstorageengine/archive/2008/03/23/minimal-logging-changes-in-sql-server-2008-part-3.aspx

http://blogs.msdn.com/sqlserverstorageengine/archive/2008/03/23/minimal-logging-changes-in-sql-server-2008-part-2.aspx

thanks

Published Friday, October 24, 2008 1:18 AM by Sunil Agarwal

Filed under: Bulk Import/Export

Comments

	Saurabh Srivastava said: Guys, Check this update on minimal logging into a btree http://blogs.msdn.com/sqlserverstorageengine October 28, 2008 2:11 PM
	Blog do Ezequiel said: New information about the Minimal Logging feature available with SQL Server 2008 using the Trace Flag November 3, 2008 6:51 PM

Anonymous comments are disabled

About Sunil Agarwal

Sunil Agarwal is a Program Manager in the SQL Server Storage Engine Group at Microsoft. He is responsible for concurrency, indexes, tempdb, LOBS, supportability, and bulk import/export. Prior to joining Microsoft, Sunil worked at DEC, Sybase, BMC Software and DigitalThink, focusing primarily on core database engine technologies and related applications.