right... I can see how that would work - and actually, it's a better way than stopping the service.. . And also know that you can just to a sp_attach_singlefile_db on the SQL server so you don't actually have to "import" it. But, importing it allows you to put everything in one table of course. t From: isalist-bounce@xxxxxxxxxxxxx [mailto:isalist-bounce@xxxxxxxxxxxxx] On Behalf Of Mayo, Bill Sent: Friday, February 08, 2008 8:55 AM To: isalist@xxxxxxxxxxxxx Subject: [isalist] Re: isa 2004 logs We have also had success with temporarily detaching previous days databases and copying them to another SQL Server and importing them there. After the file is copied, we re-attach the database on ISA to prevent any problems there. The detach/attach is doing via OSQL commands in a script, which also includes the file copy (detach database, copy database files, re-attach database). I would imagine it would be a bad idea to try detaching the current day's database! Bill Mayo ________________________________ From: isalist-bounce@xxxxxxxxxxxxx [mailto:isalist-bounce@xxxxxxxxxxxxx] On Behalf Of Thor (Hammer of God) Sent: Friday, February 08, 2008 11:50 AM To: isalist@xxxxxxxxxxxxx Subject: [isalist] Re: isa 2004 logs MSDE is the "local" SQL engine. While you could run the SQL service manager and changed the default configuration from "shared memory" also enabling "TCP" as a server option in order to connect directly to the engine for queries, I don't recommend doing that on your firewall. If you don't want to configure ISA to log to a "real" SQL server, then you have the option of stopping the SQL instance and copying the MDF files over to another SQL server (SQL Express 2005 works great unless you need a db bigger than 4g) and attach to the MDF file. Then you can start the SQL engine back up and work "off-line" so to speak. You won't be able to copy them with the service running as all the MDFs will be in use. t From: isalist-bounce@xxxxxxxxxxxxx [mailto:isalist-bounce@xxxxxxxxxxxxx] On Behalf Of James May Sent: Friday, February 08, 2008 8:30 AM To: isalist@xxxxxxxxxxxxx Subject: [isalist] isa 2004 logs Hello, I recently enabled logging to MSDE format on ISA 2004. I'm not familiar with this type of file format can anyone help as to where I might find a good program to view the contents or a how to article? Thanks, James May