February 9, 2017 at 9:07 pm
How to increase the error log files in sql 2012 , when I click on configure I did not find options to modify.
Thanks..
February 9, 2017 at 10:22 pm
I go into SSMS and expand the Management folder and right click on the SQL Server Error logs and choose Configure.
February 9, 2017 at 11:08 pm
Hi,
try this:
USE [master]
GO
EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'NumErrorLogs', REG_DWORD, 32
GO
This will configure up to 32 ERRORRLOG files
Kind regards,
Andreas
February 10, 2017 at 6:22 am
After increase the number of log files, I use a job to run weekly and create one new file for week.
https://msdn.microsoft.com/en-us/library/ms182512.aspx?f=255&MSPPError=-2147217396
This avoid larger error log files.
Fabrício França Lima
MCITP – Database Administrator
https://www.fabriciolima.net/Blog
February 13, 2017 at 9:22 pm
This was removed by the editor as SPAM
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply