[isalist] Re: isa 2004 logs

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



Other related posts: