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?
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.
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.
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...