DTS and non-logged operation - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

DTS and non-logged operation

Author

Topic

Yong Ji
Starting Member

5 Posts

Posted - 2007-10-21 : 13:57:44

Hi
The following is a possible "Non-Logged" Operations:
SELECT INTO
BULK INSERT
CREATE INDEX
WRITETEXT, UPDATETEXT
TRUNCATE TABLE (always minimally logged)
ODBC based BCP (SQL 7.0 >=)
IRowsetFastLoad (used by DTS & SQLXMLBulkLoad)

Which of the DTS operations is non-logged operation?
Is 'Bulk insert task' alone a non-logged operation or can 'Transform Data Task' also be a non-logged operation?
if 'Transform Data Task' is one of the possilbe non-logged operations, what is the prerequisites other than recovery model?

Thank you in advance.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-10-21 : 17:19:21

Sql still logs those non-logged operations without details.

Yong Ji
Starting Member

5 Posts

Posted - 2007-10-21 : 21:48:44

I know that they only log extent allocation information.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources