how to change number of errorlog files kept by server

21/05/2008, 17h48

Hi folks
Does anybody know how to change the default number of 6 errorlog files to
let say 15?

21/05/2008, 18h22

Gene,

You need to modify a register entry.

HKEY_LOCAL_MACHINE
Software\Microsoft\MSSQLServer\MSSQLServer

NumErrorLogs

In SSMS, Manegement - SQL Server Logs - Configure.

AMB

"Gene." wrote:

> Hi folks
> Does anybody know how to change the default number of 6 errorlog files to
> let say 15?

21/05/2008, 18h26

thank you Alejandro, very sharp, Gene.

"Alejandro Mesa" wrote:

> Gene,
>
> You need to modify a register entry.
>
> HKEY_LOCAL_MACHINE
> Software\Microsoft\MSSQLServer\MSSQLServer
>
> NumErrorLogs
>
> In SSMS, Manegement - SQL Server Logs - Configure.
>
> AMB
>
> "Gene." wrote:
>
> > Hi folks
> > Does anybody know how to change the default number of 6 errorlog files to
> > let say 15?

21/05/2008, 17h48	#1
Gene. Messages: n/a Hébergeur:	how to change number of errorlog files kept by server Hi folks Does anybody know how to change the default number of 6 errorlog files to let say 15?

21/05/2008, 18h22	#2
Alejandro Mesa Messages: n/a Hébergeur:	RE: how to change number of errorlog files kept by server Gene, You need to modify a register entry. HKEY_LOCAL_MACHINE Software\Microsoft\MSSQLServer\MSSQLServer NumErrorLogs In SSMS, Manegement - SQL Server Logs - Configure. AMB "Gene." wrote: > Hi folks > Does anybody know how to change the default number of 6 errorlog files to > let say 15?

21/05/2008, 18h26	#3
Gene. Messages: n/a Hébergeur:	RE: how to change number of errorlog files kept by server thank you Alejandro, very sharp, Gene. "Alejandro Mesa" wrote: > Gene, > > You need to modify a register entry. > > HKEY_LOCAL_MACHINE > Software\Microsoft\MSSQLServer\MSSQLServer > > NumErrorLogs > > In SSMS, Manegement - SQL Server Logs - Configure. > > AMB > > "Gene." wrote: > > > Hi folks > > Does anybody know how to change the default number of 6 errorlog files to > > let say 15?

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email