Microsoft KB Archive/820390

= How to manually export and import event logging and peformance data =

Article ID: 820390

Article Last Modified on 4/22/2004

-

APPLIES TO


 * Microsoft Application Center 2000 Standard Edition
 * Microsoft Application Center 2000 Standard Edition
 * Microsoft Application Center 2000 Service Pack 2

-



IN THIS TASK

 * SUMMARY
 * Create SQL Script Files
 * Create Export and Import Batch Files
 * Run the Export Batch File
 * Upgrade to Application Center 2000 SP2
 * Run the Import Batch File



SUMMARY
This article describes how to manually export and import Event Logging and Performance Counter data held in the MSSQL$MSAC database on Application Center 2000 computers.

back to the top

Create SQL Script Files
To create Backup.sql, follow these steps:  Click Start, and then click Run. Type notepad.exe .  Paste the following text in Notepad: backup database aclog to disk = 'c:\aclog.bak' go  Click File, and then click Save As. In the Save as type list box, click All Files, and then save the file as Backup.sql.

To create Restore.sql, follow these steps:  Click Start, and then click Run.</li> Type notepad.exe .</li>  Paste the following text in Notepad: use master alter database aclog Set Single_User with Rollback Immediate go restore database aclog from disk = 'c:\aclog.bak' go </li> Click File, and then click Save As.</li> In the Save as type list box, click All Files, and then save the file as Restore.sql.</li></ol>

back to the top

Create Export and Import Batch Files
To create an export batch file, follow these steps:  Click Start, and then click Run.</li> Type notepad.exe .</li>  Paste the following text in Notepad: Osql.exe -E -S .\MSAC -i c:\backup.sql -o c:\backup_log.txt </li> Click File, and then click Save As.</li> In the Save as type list box, click All Files, and then save the file as Export.bat.</li></ol>

To create an import batch file, follow these steps:  Click Start, and then click Run.</li> Type notepad.exe .</li>  Paste the following text in Notepad: Osql.exe -E -S .\MSAC -i c:\restore.sql -o c:\restore_log.txt </li> Click File, and then click Save As.</li> In the Save as type list box, click All Files, and then save the file as Import.bat.</li></ol>

back to the top

Run the Export Batch File
To run the export batch file, follow these steps.

Note You must run the Export.bat file while your computer is still part of an existing cluster.
 * 1) Copy the SQL script files and the batch files to drive C.
 * 2) Click Start, and then click Run.
 * 3) Type explorer.exe.
 * 4) Expand My Computer, and then click drive C.
 * 5) Locate and then double-click Export.bat.
 * 6) Locate and then double-click Backup_log.txt.
 * 7) Make sure that the log file indicates that the batch file was successful.

back to the top

Upgrade to Application Center 2000 SP2
To upgrade to Application Center 2000 Service Pack 2 (SP2), see the Readme.htm file on the Application Center 2000 SP2 CD.

back to the top

Run the Import Batch File
To run the import batch file, follow these steps.

Note You must run the Import.bat file after you add your computer to an Application Center 2000 SP2 cluster.
 * 1) Click Start, and then click Run.
 * 2) Type explorer.exe.
 * 3) Expand My Computer, and then click drive C.
 * 4) Locate and then double-click Import.bat.
 * 5) Locate and then double-click Restore_log.txt.
 * 6) Make sure that the log file indicates that the batch file was successful.

Note If the performance data does not appear in the Application Center 2000 Microsoft Management Console (MMC), restart your computer.

back to the top

Keywords: kbhowtomaster KB820390

-

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

© Microsoft Corporation. All rights reserved.