PRB: Filter on Saved Profiler Trace Replaces Previous File

ID: Q198064

The information in this article applies to:

Microsoft SQL Server version 7.0

SYMPTOMS

When saved with new filters applied, the SQL Server Profiler replaces the original trace file from a previously saved trace file. The filtered data is deleted from the file before the save and cannot be recovered.

CAUSE

This is by design. This intended behavior allows a large trace file to be filtered to just the required information.

WORKAROUND

If the original trace is still required, it is a good practice to make a copy of the original trace file before filtering.

Additional query words: Prof

Keywords :
Version : winnt:7.0
Platform : winnt
Issue type : kbprb