Problem replaying traces with rollover

  • ChrisMoix-87856

    SSCertifiable

    Points: 7288

    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

  • Jack Corbett

    SSC Guru

    Points: 184380

    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

  • ChrisMoix-87856

    SSCertifiable

    Points: 7288

    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 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply