December 3, 2015 at 12:32 pm
I have created a trace from production server and saved it to a file. Now I opened it in Profiler and need to replay it on dev server. How can I insure that it will NOT replay on production again?
If I open it with fn_trace_gettable function in SSMS, it displays production server name in ServerName field.
Thanks
December 3, 2015 at 2:05 pm
Replay a Trace File (SQL Server Profiler)
3.In the Replay Configuration dialog box, on the Basic Replay Options tab, specify the Replay server. Click Change to change the server displayed in the Replay server box.
OTOH, if you want to ensure 3 can never be done, delete the trace file.
December 3, 2015 at 3:11 pm
How I can get to Replay Configuration dialog box ? Is it in Profiler? My version is 2008 R2 and I don't see it anywhere.
Replay menu has only this items: Step, Start, Run to cursor, Toggle breakpoint, and these grayed out items: Pause, Stop, Settings.
Tools menu has Options but it does not have replay configuration.
File/properties lists Trace provider server name, but there is no way to change it.
December 3, 2015 at 3:59 pm
See the URL I offered, step 2.
December 4, 2015 at 1:52 pm
Now I got it. Thanks.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply