October 7, 2008 at 1:44 pm
I have a problem that is driving me crazy. I have a set of trace files (.trc, .trc_1, .trc_2, etc.) that were captured from a SQL server 2000 machine. I am replaying them on a SQL Server 2005 server (with all of the pertinent databases).
I can replay the trace files one at a time, but I cannot get them to play the rollover files automatically. I followed the online instructions and went into Tools, Options and selected "Load all rollover files in sequence without prompting" but the trace replay always stops at the end of the first file (.trc).
I don't know if this issue is because the traces were captured on SQL 2000 and being replayed in SQL 2005 or what.
Does anyone have any ideas?
TIA,
Chris
October 7, 2008 at 2:40 pm
You could try loading the files into a table and replay the trace from the table.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 8, 2008 at 6:11 am
We did try that, then Profiler complained that there were events missing. The traces replay from the files just fine.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply