[isapros] Something new on ISATools.org
- From: Jim Harrison <Jim@xxxxxxxxxxxx>
- To: "'isapros@xxxxxxxxxxxxx'" <isapros@xxxxxxxxxxxxx>
- Date: Sat, 17 May 2008 15:08:32 -0700
http://isatools.org/tools/msde_bcp.zip
It's a script to provide a MSDE or local-SQL ISA log export.
I originally wrote it for MSIT, but other folks asked for a "less specific"
version, so here it is.
It will export your log data to the destination folder of your choice (local or
remote).
How is this different from other similar tools?
1. it uses SQL bulk copy (BCP), which is self-throtting (read: won't choke your
ISA)
2. avoid the whole detach, copy, reattach (or delete) mess
3. logs all activity to %windir%\temp\msde_bcp.wsf.log
4. avoids the current or future logs to prevent contention (and thus lockdown)
5. works in a standalone or array environment
6. provides self-debugging capability (only available via Jscript; VBscript
isn't nearly as self-aware).
The readme gives you examples and requirements.
Feel free to send me bugz, complaints, death threats, large sums in small,
unmarked bills, etc.
Jim
Other related posts:
