April 7, 2005 at 10:58 pm
Hi All,
Suggest me if it is possible- SQL Server 2000 maintains 7 error log files (by default). One Current & other six Older. What I need to do is to replace all those 7 files with a single file with a property of auto grow to a size unlimited. Please give solutions whether it can be done & how.
April 8, 2005 at 2:51 am
I suspect that you can't have an autogrowing file but there is a registry setting that allows you to specify the number of logs you keep.
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer] "NumErrorLogs"=dword:00000010
The problem with having a small number of error log files is that someone could run DBCC ERRORLOG to force a rollover of the logs. Do that 7 times in your case and the logs are completely flushed hiding whatever values were supposed to be there
April 8, 2005 at 9:21 am
Correct me if I'm wrong please, but if you change the registry value to only keep only one log file, then restart SQL Server, won't you lose the previous log and therefore all of your historic info? I don't know that there's a way to force SQL Server to open the previous log on restart rather than creating a new one but perhaps someone else does.
My hovercraft is full of eels.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply