Browse by Tags

SQL Server Integration Services and Clustering - confguration gotcha to ensure SSIS works with failover of cluster!
17 March 08 01:06 PM | ssqa.net | with no comments

A newbie or FAQ within Forums and Newsgroups that having multiple instances and how best to set the resources on the server such as memory, CPU etc. Read more from here.

Filed under: sql server, best practices, configuration, benefits, management studio, multiple, memory, instances, cpu

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