Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

[edi-l] How to purge (or reduce the size of) the Gentran Database Log

Status
Not open for further replies.

Jeff04

IS-IT--Management
Oct 9, 2008
7
US
I'm new to Gentran and would like to know how to reduce and/or purge the GentranDataBase_Log.LDF? I'm running Gentran Server for Windows NT, version 3.2 SP1. I am basically out of space on my hard drive and them seems to be a file I can free up a lot of space with.

Any help would be greatly appreciated.

Thanks
Jeff
 
Jeff,

While I'm not a DBA, if space is a concern, there are a few things you can do to help from the application side.

- Make sure you have a job scheduled to purge your audit log. You can then either delete what is purged, or at least back it up elsewhere.

- Set up archiving. You can set this up to run automatically, and save the archive files on another drive/server

I hope these help you, if you have any more questions or need more information to set this up, feel free to ask.

Jodi Ellenzweig
CONTAX Inc.
jodi.ellenzweig@contax.com
 
Jeff,

I just wanted to follow up and see if you were able to improve your Gentran storage situation?

You mentioned you were new to Gentran, so if there is anything else you need help with, please let me know!

Thanks,

Jodi Ellenzweig
CONTAX Inc.
jodi.ellenzweig@contax.com
 
A mentioned you can purge the log. Open up the Gentran administration tool and purge the log from there.
Archive the messages as soon as you can noting that it takes forever to search these archiving messages if you were needing to retrieve their data.
Kevin
- All things EDI related
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top