June 18, 2015 at 11:44 am
SQL SERVER 2008R2
The number of files to retain for SQL Server Logs is set to 99. When I expand the SQL Server Logs node in SQL Server Mgt Studio it shows the current log file through Archive#49. The oldest archive file is dated 2015/05/26. If I select that archive in SQL Server Mgt Studio it shows me the details and entries of that archive file. Yet when I go to the directory on SQL Server for the log files there are only the 5 most recent files. I have searched for '.trc' files on the entire drive and have found no other files.
How can SQL Server Mgt Studio show archive files that have no corresponding archive file in the directory that is supposed to contain the log files?
Thanks
Kindest Regards,
Just say No to Facebook!June 18, 2015 at 1:56 pm
The .trc files are for the default trace, not the error log.
If you just have default settings for the location and name, the error log files will be showing as something like ERRORLOG.1, ERRORLOG.2, etc.
If you have changed the name with the startup parameters, you can either check the startup parameters, or look at the beginning of the error logs, and it will show the path and file name being used.
Cheers!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply