From: Moscow, Russia
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 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.