Browse by Tags

SQL Server 2005 Agent XPs disabled error - how to resolve this issue?

Published 6 February 8 2:38 AM | SSQA.net

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

Filed under: sql server, profiler, security, services, sqlagent, sa, error log, msdtc, group policy

Cluster resource 'SQL Server (<SQL Server instance name>)' in Resource Group '<Cluster group name>' failed.

Published 10 October 7 4:31 PM | SSQA.net

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, dba, sqlagent, best practices, cluster, error log, online, failure, active/passive

Recovery of database 'dbname' (10) is 17% complete (approximately 31602 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.

Published 5 September 7 3:13 AM | SSQA.net

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

Filed under: sql server, performance, databases, sqlagent, error log, recovery, suspect, message

Change SQLAgent log file location after SQL Server installation

Published 11 July 7 4:17 AM | SSQA.net

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

Filed under: sql server, log, sqlagent, error log, location, path