|
Home > Archive > MS SQL Server DTS > July 2005 > shrink dts step log
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
shrink dts step log
|
|
|
| Hey eb
My dts step log is growing to much.
I want to add a step to this dts which will
shrink it by deleting records from table msdb.sysdtssteplog
(keeping records that are no more than 1 week old).
Is this possible??
Are there any other ways to keep this log economical
while it is being used ?
TIA
Rea
| |
| Darren Green 2005-07-27, 8:24 pm |
| In message <69DF5032-4DE9-49B6-A551- 16246450CF82@microso
ft.com>, Rea
<Rea@discussions.microsoft.com> writes
>Hey eb
>My dts step log is growing to much.
>I want to add a step to this dts which will
>shrink it by deleting records from table msdb.sysdtssteplog
>(keeping records that are no more than 1 week old).
>Is this possible??
>Are there any other ways to keep this log economical
>while it is being used ?
>TIA
>Rea
Purging the logs through T-SQL is fine. I do. There are three tables,
steps, tasks and packages.
I don't have any scripts handy, but I could dig some out.
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org
| |
|
| thanks will follow your advice!
"Darren Green" wrote:
> In message <69DF5032-4DE9-49B6-A551- 16246450CF82@microso
ft.com>, Rea
> <Rea@discussions.microsoft.com> writes
>
> Purging the logs through T-SQL is fine. I do. There are three tables,
> steps, tasks and packages.
>
> I don't have any scripts handy, but I could dig some out.
>
> --
> Darren Green (SQL Server MVP)
> DTS - http://www.sqldts.com
>
> PASS - the definitive, global community for SQL Server professionals
> http://www.sqlpass.org
>
>
|
|
|
|
|