How to manually remove the MSDE database in ISA Server 2004 (838707)


The information in this article applies to:

  • Microsoft Internet Security and Acceleration Server 2004, Standard Edition

INTRODUCTION

This article describes how to manually remove the Microsoft SQL Server 2000 Desktop Engine (MSDE) database in Microsoft Internet Security and Acceleration (ISA) Server 2004. ISA Server 2004 uses the MSDE for logging operations.

MORE INFORMATION

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:
  1. Click Start, click Run, type cmd in the Open box, and then click OK.
  2. 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.
  3. At the SQL command prompt, type the following command, and then press ENTER:

    EXEC sp_detach_db @dbname=DatabaseName

  4. Type go, and then press ENTER.
The database is detached and you can now successfully delete the database files.
Modification Type:MajorLast Reviewed:7/16/2004
Keywords:kbhowto kbinfo KB838707 kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.