asked on
MSSQL server trace file
Hi,
Our mssql server mountpoint growing faster due to SQL server profiler - trace data file.
Around 3 years files available in the location and using up 200GB disk space.
May I know if can we delete some of the audit trace file in mssql?
Is this will cause any impact to our GFI data?
Please advice,
Thanks,
GFI-audittrace-files.PNG
Our mssql server mountpoint growing faster due to SQL server profiler - trace data file.
Around 3 years files available in the location and using up 200GB disk space.
May I know if can we delete some of the audit trace file in mssql?
Is this will cause any impact to our GFI data?
Please advice,
Thanks,
GFI-audittrace-files.PNG
Microsoft SQL Server 2008
Last Comment
Deepak Chauhan
ASKER
Hi Deepak,
Thanks for the advice,
There are a lot of files in the location.
How to zip by years?
Can I run command to delete the files?
Please advice,
Thanks,
Thanks for the advice,
There are a lot of files in the location.
How to zip by years?
Can I run command to delete the files?
Please advice,
Thanks,
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
If you want to retain this data then you can compressed the OLD trace files using winzip or Windows default compression tools.
However no impact on sql server if you delete these files.