May 1, 2012 at 11:16 am
As we can see many number of error logs in log folder of mssqlserver, so i wish to know the purpose of these maintenance.
please tell me?
May 1, 2012 at 11:19 am
Not sure what you are really asking. You can establish how many previous logs you wish to retain. The default is 6 log files including the current, iirc.
May 1, 2012 at 12:44 pm
Hmmm, Google must have been broken again mohan.bndr. Using an exact phrase from your original post I see many results that can help you understand SQL Server Error Logs:
error logs in log folder of mssqlserver
First result:
SQL Server 2005 Error Log Management[/url]
Third result:
Viewing the SQL Server Error Log
Please try before posting next time. Most of your questions can be answered with a simple internet search, and a few minutes of reading.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 1, 2012 at 8:35 pm
If you are looking to retrieve the max number of error log files, then run this query:
use master
go
declare @max_log_files int
exec xp_instance_regread
N'HKEY_LOCAL_MACHINE',
N'Software\Microsoft\MSSQLServer\MSSQLServer',
N'NumErrorLogs', @max_log_files output
select @max_log_files
Notice, this is stored in the registry. Also worth noting, if this isn't changed from the default ever (6 is default), then this key will not exist.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply