When SQL Server 2005 Management Studio's Object Browser shows the SQL Server Agent service with a red down arrow and the text Agent XP's disabled , the service is not started or disabled. This used to be a problem prior to Service Pack 2 for SQL Server 2005, obviously SQLAgent is important part...
A common mistake by DBAs for missing to check whether all the functionality of tools are working when a SQL Server Cluster environment is setup, though you may not catch hold of few issues with basic failover/failback testing initially but when the application is initiated and data is stored with relevant...
Though the message specifies as an informational message only and no user action is required, you should take some action to avoid current behaviour of databases within your environment. Also check whether you have enabled the AUTO_CLOSE property for any of the databases on that SQL Server instance,...
Can we change the location of SQL agent error log file after the SQL Server program is installed? Yes, i n terms of configuring a specified number of SQL Server Agent error logs, this is not possible. The default number of log files for SQLAGent is 9 that can be retained. On top of that if you want to...