How to manually export and import event logging and peformance data (820390)

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:

1. Click Start, and then click Run.
2. Type notepad.exe.
3. Paste the following text in Notepad:

   backup database aclog to disk = 'c:\aclog.bak'
   go

4. Click File, and then click Save As.
5. 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:

1. Click Start, and then click Run.
2. Type notepad.exe.
3. 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

4. Click File, and then click Save As.
5. In the Save as type list box, click All Files, and then save the file as Restore.sql.

back to the top

Create Export and Import Batch Files

To create an export batch file, follow these steps:

1. Click Start, and then click Run.
2. Type notepad.exe.
3. Paste the following text in Notepad:

   Osql.exe -E -S .\MSAC -i c:\backup.sql -o c:\backup_log.txt

4. Click File, and then click Save As.
5. In the Save as type list box, click All Files, and then save the file as Export.bat.

To create an import batch file, follow these steps:

1. Click Start, and then click Run.
2. Type notepad.exe.
3. Paste the following text in Notepad:

   Osql.exe -E -S .\MSAC -i c:\restore.sql -o c:\restore_log.txt

4. Click File, and then click Save As.
5. In the Save as type list box, click All Files, and then save the file as Import.bat.

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