Limiting log growth during DTS Package
- From: davisutt <davisutt@xxxxxxx>
- Date: Tue, 24 Jul 2007 13:49:09 -0700
SQL Server 2000 SP4. I built a large DTS package that grabs a number
of tables from an Oracle DB, does some scrubbing and date verification
and loads to a SQL Server DB. Most of the tables are full refresh and
a few are incremental.
Main DW: DwSQL
Staging Area: DwLoadAreaSQL
The DW is about 60 Gigs. The Staging Area is about 80 Gigs. This is
all good.
However, the log file for the staging area is 50 Gigs and I'm trying
to find ways to not require such a large log file. I tried adding a
few "BACKUP LOG DwLoadAreaSQL WITH TRUNCATE_ONLY" statements in the
DTS package but figured out that because it's 1 DTS package it's all 1
transaction. I've thought about breaking it up into multiple DTS
packages and truncating the log between running them but was hoping to
avoid this. To be clear, I know how to shrink DB's and Log
Files...that's not the issue.
Any Ideas? Thanks.
.
- Follow-Ups:
- Re: Limiting log growth during DTS Package
- From: kmounkhaty
- Re: Limiting log growth during DTS Package
- Prev by Date: Domain policy to disable XP firewall causes SQL client slowdown
- Next by Date: Database 'msdb' cannot be opened due to inaccessible files or insufficient memory or disk space.
- Previous by thread: Domain policy to disable XP firewall causes SQL client slowdown
- Next by thread: Re: Limiting log growth during DTS Package
- Index(es):
Relevant Pages
|
