Browse by Tags

Cluster resource 'SQL Server (<SQL Server instance name>)' in Resource Group '<Cluster group name>' failed.
13 March 08 09:05 AM | ssqa.net | with no comments

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...

Filed under: sql server, best practices, sqlagent, error log, online, dba, failure, active/passive, cluster

Is there a way of recylce the SQLAgent.out file in SQL Server 2000 and SQL Server 2005?
21 February 08 08:44 AM | ssqa.net | with no comments

You may be aware about SP_CYCLE_ERRORLOG from older SQL Server versions, this will only take care of SQL Server error log and not with SQLAgent error log. So the question is there any way out to recycle the SQLAgent log file too without restarting this...

Filed under: sql server, advanced, sqlagent.out, sqlagent, agent, configuration, error log, restart, services