Welcome to ISAserver.org

Logging to SQL - base full

Users viewing this topic: none

Logged in as: Guest

Printable Version

All Forums >> [ISA Server 2004 Firewall] >> Logging and Reporting >> Logging to SQL - base full

Page: [1]

Message

<< Older Topic Newer Topic >>

Logging to SQL - base full - 26.Mar.2004 5:23:00 PM

Custler

Posts: 23
Joined: 24.Feb.2004
From: Moscow, Russia
Status: offline

I am configure ISA to write logs to SQL server. Database file size is 2GB.
All working fine until free space in database comes to end. I receive the alert "Log failure" with Description:
================
The ISA Server Web filter failed to log information to ODBC Data Source ISA, Table: WebProxyLog, under User Name [ISAlogs]. The ODBC Error description is: [State=01004][Error=0][Microsoft][ODBC SQL Server Driver]Fractional truncation [State=37000][Error=1105][Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object 'WebProxyLog' in database 'ISA Logs' because the 'PRIMARY' filegroup is full. . For more information about this event, see ISA Server Help.
==============
What I am misconfigure, or ISA cannot rotate SQL database?

Post #: 1

Featured Links*

RE: Logging to SQL - base full - 29.Mar.2004 7:58:00 PM

duunoit

Posts: 2
Joined: 11.Mar.2004
Status: offline

I moved mine to SQL also and was worried about the log size (the real problem is that whitespace is userd to fill up the entire field), so I just went back to text logging.

(in reply to Custler)

Post #: 2

RE: Logging to SQL - base full - 30.Mar.2004 10:16:00 AM

tshinder

Posts: 50013
Joined: 10.Jan.2001
From: Texas
Status: offline

Hi Chris,

I think I'll end up going back to text logging as well. There are no documented methods available right now to export the MSDE files to text, and having this ability is critical in a number of situations. At least, I'll use text files until I get around to figuring out how to use the DTS Wizard.

Thanks!
Tom

(in reply to Custler)

Post #: 3

RE: Logging to SQL - base full - 19.Aug.2004 9:55:00 AM

liuty2006

Posts: 88
Joined: 30.Jun.2004
Status: offline

try this one -- more professional!less memory need!
netfee for isa server
http://www.netfeesoftware.com

(in reply to Custler)

Post #: 4

RE: Logging to SQL - base full - 26.Aug.2004 5:32:00 PM

grinn253

Posts: 76
Joined: 12.Jul.2004
From: Seattle
Status: offline

quote:
Originally posted by tshinder:
...There are no documented methods available right now to export the MSDE files to text, and having this ability is critical in a number of situations...

Hi there, from http://www.microsoft.com/technet/prodtechnol/isa/2004/plan/faq-monitoring.mspx
Mentions:
Q. How can I export my MSDE files to text?
A. The script MSDEToText.vbs is available on the ISA Server CD.

Perhaps that may help?
Edgardo

(in reply to Custler)

Post #: 5

RE: Logging to SQL - base full - 28.Aug.2004 9:23:00 PM