Is it possible to import from SQL Server or text file, to version 7, and
turn off transaction logging?

I'm failing for full tlog due to no drive space.

thx
md

*** Sent via Developersdex http://www.developersdex.com ***

Hi M D,

"M D" wrote:
you never can stop logging, but if you change the logging of the DB to
Bulk-Logged, then you can run bulk loads with minimal logging.
Then you can use bcp.exe or the bulk insert or the corresponding DTS task,
to import data with minimal logging.
See BOL for a description of "BULK_LOGGED RECOVERY" to understand the
features and drawbacks.

Helge

Helge

Because the DB is SQL Server 7 did you mean to specify these options

select into/bulkcopy and trunc. log on chkpt.


Recovery models came in for SQL Server 2000 IIRC.

Allan


"Helge C. Rutz" wrote:

Hi Allan,

"Allan Mitchell" wrote:
you're absolutly right. I must admit, I missed the version detail when read
the post, sorry.
With SQL 7 you have to configure this behaviour different - as you
described.
@MD: Also watch for the TABLOCK hint for bulk insert.
@Allan: Was this hint already available for the SQL7 bulk insert DTS task?
I can't remember.
BTW: I haven't seen SQL Server 7 in real life for over a year ;-)

Helge