top of page

SQL Server Script to increase number of Errorlogs

--Below script will change the number of SQL Server errorslogs to 10


USE [master]

GO

EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'NumErrorLogs', REG_DWORD, 10

GO


4 views0 comments

Recent Posts

See All

Comments


bottom of page