Since SQL Trace collects so many files, it may be beneficial to have the trace file zip everything at the end of the process so the customer can upload just that zip file. Before we had SQLTrace, I wrote out my own script with the following:
POWERSHELL -command "Compress-Archive -Path .\SQLTrace -DestinationPath .%computername%_SQLTrace.zip"
ECHO.
ECHO I have zipped the contents of this directory as %computername%_SQLTrace.zip, stored in the same directory you ran the batch file from.
ECHO Please upload this file to the DTM site provided by your support engineer.
ECHO I have also paused the batch file so you can review the command buffer.
ECHO.
PAUSE
Since SQL Trace collects so many files, it may be beneficial to have the trace file zip everything at the end of the process so the customer can upload just that zip file. Before we had SQLTrace, I wrote out my own script with the following:
POWERSHELL -command "Compress-Archive -Path .\SQLTrace -DestinationPath .%computername%_SQLTrace.zip"
ECHO.
ECHO I have zipped the contents of this directory as %computername%_SQLTrace.zip, stored in the same directory you ran the batch file from.
ECHO Please upload this file to the DTM site provided by your support engineer.
ECHO I have also paused the batch file so you can review the command buffer.
ECHO.
PAUSE