Microsoft KB Archive/838707

= How to manually remove the MSDE database in ISA Server 2004 =

Article ID: 838707

Article Last Modified on 7/16/2004

-

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_ _FWS_ .mdf
 * ISALOG_ _WEB_ .mdf

When you try to manually delete an ISA Server 2004 database file, you may receive the following error message:

Cannot delete ISALOG_ _FWS_ : 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:

&quot;%ProgramFiles%\Microsoft SQL Server\80\Tools\Binn\OSQL.EXE&quot; -S \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=

 Type go, and then press ENTER.

The database is detached and you can now successfully delete the database files.

Keywords: kbhowto kbinfo KB838707

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.