Will bcp out command or auto-shrink create lots of tran-log in the database?

#1

hi,

working on sql server 2000.

Will bcp out command create lots of tran-log in the
database?

Will auto-shrink create lots of tran-log in the database?

thanks a ton.

JJ

#2

In article <0bb401c3aa36$08d5efa0$a001280a (AT) phx (DOT) gbl>, JJ Wang
<anonymous (AT) discussions (DOT) microsoft.com> writes

Quote:

hi,

working on sql server 2000.

Will bcp out command create lots of tran-log in the
database?

Exporting data does not write anything or change the existing data or
indexes so there is no transaction log writes required.

Quote:

Will auto-shrink create lots of tran-log in the database?

Don't use auto-shrink. It is not very efficient. Size your log (and

data) files up front.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Will bcp out command or auto-shrink create lots of tran-log in the database?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Will bcp out command or auto-shrink create lots of tran-log in the database? - 11-13-2003 , 04:32 PM

Re: Will bcp out command or auto-shrink create lots of tran-log in the database? - 11-13-2003 , 05:15 PM