Microsoft KB Archive/323144

= HOW TO: Move MSDE$MSAC to a Different Location =

PSS ID Number: 323144

Article Last Modified on 10/26/2002

-

The information in this article applies to:


 * Microsoft Application Center 2000

-



This article was previously published under Q323144



IN THIS TASK

 * SUMMARY
 * ** Turn Off Performance Logging
 * Stop the SQL Server Agent
 * Connect to the Database, Detach the Database, and then Move the Database File
 * Reattach the Database in the New Location
 * Restart Performance Counters



SUMMARY
This step-by-step article explains how to move the Microsoft Application Center named instance of the MSDE database that is installed with Application Center 2000.

NOTE: You must install Microsoft Application Center 2000 before you can follow this procedure. You cannot do this during installation of Application Center 2000.

back to the top

Turn Off Performance Logging
Before you can move the database, you must turn off performance logging. To do this, follow these steps:
 * 1) Click Start, point to Programs, point to Administrative Tools, and then click Application Center 2000.
 * 2) Expand the Application Center node, expand the cluster name, right-click Events, and then click Properties.
 * 3) Clear the check box for the Enable Performance Counter Logging option, and then click OK.

back to the top

Stop the SQL Server Agent
After you have turned off performance logging, stop the SQL Server Agent. To do this, follow these steps:
 * 1) Click Start, click Run, type cmd.exe in the text box, and then press ENTER.
 * 2) Type Net Stop SQLAgent$MSAC, and then press ENTER.

back to the top

Connect to the Database, Detach the Database, and then Move the Database File
To move the database, follow these steps:
 * 1) Switch to the directory C:\Program Files\Microsoft SQL Server\80\Tools\Binn.
 * 2) Type OSQL -S  \MSAC -E (where   is the name of your computer), and then press ENTER.
 * 3) Type sp_detach_db ACLog, and then press ENTER.
 * 4) Type go.
 * 5) Open Windows Explorer, locate the folder C:\Program Files\Microsoft SQL Server\MSSQL$MSAC\Data, and then move the file ACLog.mdf to a different location on the computer.

back to the top

Reattach the Database in the New Location
To reattach the Application Center named instance of the MSDE database from the new location, follow these steps:
 * 1) Switch to the open Cmd.exe window.
 * 2) Type sp_attach_single_file_db ACLog, , and then press ENTER.
 * 3) Type Exit, and then press ENTER.
 * 4) Type Net Start SQLAgent$MSAC, and then press ENTER.

back to the top

Restart Performance Counters
To restart the performance counters, follow these steps:
 * 1) Switch to the Application Center 2000 Console.
 * 2) Right-click the Events node, and then click Properties.
 * 3) Click to select the check box for the Enable Performance Counter Logging option, and then click OK.

back to the top

Keywords: kbhowto kbHOWTOmaster KB323144

Technology: kbACenter2000 kbACenterSearch kbAudDeveloper

-

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

© 2003 Microsoft Corporation. All rights reserved.