5.8

4. To open the debug log viewer, right-click the following executable, andRun As Administrator.
ECMDebugEventViewer.exe
5. Click Filter Settings.
6. In the Message Type and Message Source areas, select all of the check boxes and click OK.
7. In the Data Source area, type the names of the servers and databases and click OK.
8. Click Date/Time, and select the between option.
9. Specify the start and end times when the job ran, and pad the times with an additional five or more
minutes at each end.
10. Click File, and select Fetch.
The displayed data refreshes.
11. Click File, and select Fetch Next.
Continue the Fetch Next process until no additional data is added to the displayed debug log.
12. Click File, and select Save as DBE.
13. Name the DBE file and note where it is saved.
What to do Next
Using "Set the Debug Log to Store all Message Types" on page 21 as a guideline, restore the original
logging levels. Usually, you only log Exception, Error, and Warning messages.
Extract SQL Server Logs
To save messages about database operations, extract SQL Server logs.
Procedure
1. On your SQL Server machine, open SQL Server Management Studio.
2. Select the server name and authentication method, and click Connect.
3. In the Object Explorer pane, expand server-name > Management > SQL Server Logs.
4. Right-click a log, and select View SQL Server Log.
The Log File Viewer displays the logs.
5. Click Export.
The Export Last Fully Retrieved Log dialog box appears.
6. Save the logs.
Give each saved file a meaningful name and note where it is saved.
Collect IIS Logs
To save messages about VCM Web server operations, extract Internet Information Services (IIS) Server
logs.
VCM Troubleshooting Guide
22
VMware, Inc.