Welcome to the world (new face) of Knowledge Sharing Network.
To track the older blog posts refer to our historical knowledge sharing site  and you will find this as your destination for SQL Server knowledge pool.

Follow SQLMaster on Twitter SqlServer-QA.net - Knowledge Sharing Network (@sqlmaster)

↑

sql server,error log - SQL Server Knowledge Sharing Network (@sqlmaster)

Browse by Tags

All Tags » sql server » error log (RSS)
01 February 2010 15:58

The buffer manager failed a memory allocation call for 20485670 bytes, but was unable to swap out any buffers to relieve memory pressure

A typical error occurred when a simple SSIS package has been executed to export 500 rows to another SQL instance, not once atleast 3 times! More information on error text from event viewer that has been generated by the 'service; ...more from here;
Posted by ssqa.net | with no comments
Filed under: , , , , , , ,
29 June 2009 11:35

SQL Server version has a known compatibility issues with Windows 7 RC. This warning is genuine and applies to all SQL Server editions, including all Express editions.

There is no need to guess about the rootcause of the above error message, as it clearly mentions about compatibility issues as a warning.... read more !
Posted by ssqa.net | with no comments
Filed under: , , , , , , , ,
13 March 2008 09:05

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

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...
Posted by ssqa.net | with no comments
Filed under: , , , , , , , ,
21 February 2008 08:44

Is there a way of recylce the SQLAgent.out file in SQL Server 2000 and SQL Server 2005?

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...
Posted by ssqa.net | with no comments
Filed under: , , , , , , , ,