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

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

Last Reviewed: December 30, 1998