 | |
shrink dts step log
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
shrink dts step log -
07-27-2005
, 02:21 AM
#2
| |||
| |||
|
|
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 |
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
#3
| |||
| |||
|
|
In message <69DF5032-4DE9-49B6-A551-16246450CF82 (AT) microsoft (DOT) com>, Rea Rea (AT) discussions (DOT) 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 |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.