Re: dts package and t log

From: Michael Vardinghus (mivar_at_wmdata.dk)
Date: 04/13/04 

Date: Tue, 13 Apr 2004 18:44:00 +0200

Hi All..

But isn't it possible to start a dts package and as the first step use some
kind af statement to tell sql not to fill up
the log-file ? No need for this when transporting data to a dw .. error
handling will be tackled as part of the package.

Of course it could break down in the middle ... but then i would have my old
dw environment and can run it again..

If this isn't possible how can i shrink the log (backup log (database) with
no_log) AND reduce the file size to the hereafter used space.

\Michael Vardinghus

Allan Mitchell <allan@no-spam.sqldts.com> wrote in message
news:ON#4SvkHEHA.3840@TK2MSFTNGP11.phx.gbl...
> Your understanding of the T Log is slightly out then.
>
> The T Log must store all uncommitted data + any worktables.
>
> Simple mode will allow SQL Server to use the Lazy Writer (I think) and
flush
> COMMITTED transactions from the log at intervals
>
>
> http://www.support.microsoft.com/?id=317375 Log File Grows too big
> http://www.support.microsoft.com/?id=110139 Log file filling up
> http://www.mssqlserver.com/faq/logs-shrinklog.asp Shrink File
> http://www.support.microsoft.com/?id=315512 Considerations for
Autogrow
> and AutoShrink
> http://www.support.microsoft.com/?id=256650 INF: How to Shrink the SQL
> Server 7.0 Tran Log
> http://www.support.microsoft.com/?id=272318 INF: Shrinking Log in SQL
> Server 2000 with DBCC SHRINKFILE
>
>
>
> --
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>
>
> "sqlsurfer" <anonymous@discussions.microsoft.com> wrote in message
> news:7A312FCB-725D-4EE6-A067-0E9B147DA856@microsoft.com...
> > Why does the t-log appear to log the whole transaction of an import of
> data into a table when the database is in simple recovery model. I
thought
> it would only log the extents that were effected but it takes a t log that
> is as large as the file being imported e.g. a 10 gig file needs 10 gigs
> worth of t-log space.
> >
> > I know I can solve it by setting the commit batch size option but it is
> messing with my fundamental understanding of the t-log.
>
>

Relevant Pages

  • Re: Job Scheduler fails and Managing Tempdb
    ... You can turn logging on on both the job and the DTS Package to get some more ... As I said in my previous post, shrinking tempdb is not very useful. ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Source table filtering in DTS by target table values.
    ... I am new to SQL Server and to DTs. ... for the client master. ... file (created in the DTS package) and add them batch by batch ...
    (microsoft.public.sqlserver.dts)
  • Re: Batch File in DTS
    ... I assume that you are running SQL Server 2000. ... is run as a system administrator) or else of the SQL Agent proxy account. ... This works in DTS package, but when I schedule the package, ...
    (microsoft.public.sqlserver.dts)
  • Re: Creating a DTS ActiveX Task
    ... (this is the service that runs jobs in SQL Server) ... the 'logon as' tab, you'll see what account this service runs as, this is ... from the network from your DTS package you'll be fine, ... > I'm not very familiar with SQL Server, I only know some VB and TSQL. ...
    (microsoft.public.sqlserver.programming)
  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... I moved every table I was able to move to the SQL ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... communication between ODBC (OLEDB and Native Client, ...
    (microsoft.public.sqlserver.connect)