By default, ISA Server 2004 database files are stored in the following folder:
%ProgramFiles%\Microsoft ISA Server\ISALogs
These files use the following file names:
- ISALOG_yyyymmdd_FWS_nnn.mdf
- ISALOG_yyyymmdd_WEB_nnn.mdf
When you try to manually delete an ISA Server 2004 database file, you may receive the following error message:
Cannot delete ISALOG_yyyymmdd_FWS_nnn: It is being used by another person or program.
Close any programs that might be using the file and try again.
Before you can delete the database files, you must detach the database from the MSDE. To detach a database, follow these steps:
- Click Start, click Run, type cmd in the Open box, and then click OK.
- At the command prompt, type the following command, and then press ENTER:
"%ProgramFiles%\Microsoft SQL Server\80\Tools\Binn\OSQL.EXE" -S YourServerName\MSFW �E
Note The options in this command are case-sensitive. - At the SQL command prompt, type the following command, and then press ENTER:
EXEC sp_detach_db @dbname=DatabaseName
- Type go, and then press ENTER.
The database is detached and you can now successfully delete the database files.