Welcome to ISAserver.org

Backing up Firewall log files from the MSDE database

Users viewing this topic: none

Logged in as: Guest

Printable Version

All Forums >> [ISA 2006 Firewall] >> Logging and Reporting >> Backing up Firewall log files from the MSDE database

Page: [1]

Message

<< Older Topic Newer Topic >>

Backing up Firewall log files from the MSDE database - 7.Jan.2008 5:50:13 PM

MinusB27

Posts: 13
Joined: 17.Dec.2007
Status: offline

I would like to backup the Firewall log files from our ISA 2006 installation (for auditing purposes), however, these logs are stored in the MSDE on the same machine. Since MSDE has a lock on these files, its not possible to back them up without using some scripts with OSQL (backing them up like a regular SQL Server database)

I was thinking of writing a script and running it on a schedule to backup the log files, but since a new database file/log is started every day, the filenames I need to backup are constantly changing. I can make the script dynamic enough to handle this daily.

My real question is:

Is there an easier way to backup the logs in the MSDE , or rather a 'Best Practice'? I'd like to be able to automate the process if possible.

Josh Brown