The following procedure describes how to save log information to a SQL Server Express database.
To configure logging to SQL Server Express
-
In the Forefront TMG Management console, in the tree, click the Logs & Reports node.
-
In the details pane, click the Logging tab.
-
On the Tasks tab, select the appropriate task:
- Select Configure Firewall Logging to
specify that the Firewall log should be written to a local SQL
Server Express database.
- Select Configure Web Proxy Logging to
specify that the Web Proxy log should be written to a local SQL
Server Express database.
- Select Configure Firewall Logging to
specify that the Firewall log should be written to a local SQL
Server Express database.
-
On the Log tab, click SQL Server Express Database (on local server), and then click Options.
-
Select ISALogs to store logs in the default location. To store files in an alternative location, click This folder, and specify the path.
-
Configure the log size as follows:
- Select Limit total size of log files
and specify a maximum size. Each log file is limited to 1.5 GB.
When a log file reaches 1.5 GB, a new file is automatically
created.
- Select Maintain free disk space and
specify the free space.
- Select Limit total size of log files
and specify a maximum size. Each log file is limited to 1.5 GB.
When a log file reaches 1.5 GB, a new file is automatically
created.
-
Configure how logs are managed as follows:
- Select Deleting older log files as
necessary to specify that the oldest log files are deleted
automatically in accordance with the specified size limits.
- Select Discarding new log entries to
stop logging new entries (while keeping all the old log
information) in accordance with the specified size limits. New
entries are not logged until you change limits or delete old files.
An alert is issued to notify you of this event.
- Select Delete files older than to
delete log files older than the specified days. To delete old files
from storage, decrease this number.
- Select Deleting older log files as
necessary to specify that the oldest log files are deleted
automatically in accordance with the specified size limits.
-
Select Compress log files to reduce log file size. Compression is only applied to log files stored on NTFS volumes.
Note: |
---|
If you need to copy or move SQL Server Express databases from one location to another, you must first detach the database from the current server. You should never detach a database that is currently in use. |
Related Topics
Copyright © 2009 by Microsoft Corporation. All rights reserved.