Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

How to manually remove the MSDE database in ISA Server 2004


View products that this article applies to.

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.

↑ Back to the top


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.

↑ Back to the top


Keywords: KB838707, kbinfo, kbhowto

↑ Back to the top

Article Info
Article ID : 838707
Revision : 4
Created on : 7/16/2004
Published on : 7/16/2004
Exists online : False
Views : 593