Kunal RanpuraJul 28, 20191 minSQL 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',...
Kunal RanpuraJul 28, 20191 minSQL Server Agent Job to recycle error logUSE [msdb] GO /****** Object: Job [sp_cycle_errorlog] Script Date: 08/26/2014 10:44:11 ******/ BEGIN TRANSACTION DECLARE @ReturnCode...
Kunal RanpuraJul 28, 20191 minConfigure SQL Server Agent Job HistoryUSE [msdb] GO EXEC msdb.dbo.sp_set_sqlagent_properties @jobhistory_max_rows=10000, @jobhistory_max_rows_per_job=1000