Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-09-26 : 07:56:57
|
| roger writes "I have some DTS jobs that grow my transaction logs to large proportions (>5Gb). I have read and am using backup with no log and shrinkfile successfully but would to avoid this manual process if possible.The database is strictly for reporting and is overwritten with each DTS job anyway so I don't care about recovery.Thanks,Rogerrjohnson@eas-i.net" |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2003-09-26 : 11:05:33
|
| Well Roger, you could always automate this process by putting it into a job and scheduling it to run as often as you need it. Or you could add them as a final step in the DTS package.You also might look to see if there is a non-logged way to do the work you're doing. If you'd like to tell us more about what the DTS job does, we might be able to suggest some other ideas.------------------------------------------------------The more you know, the more you know you don't know. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-26 : 12:35:35
|
| Is your recovery model set to SIMPLE? If so, then change your job so that it commits the work in batches rather than in one large batch.Tara |
|
|
|
|
|
|
transaction logs