Browse by Tags

SQL Server Service Pack or Hotfix patch or Cumulative Update: do not attempt Windows System Restore as a backout plan?

Published 19 May 8 4:28 AM | SSQA.net

To cut the long story short, during a recent implementation of Cumulative Update 6 and 7 on a particular 'application domain' server we have had major application issues due to a mix up of application code & these SQL cumulative update fixes...

Filed under: sql server, restore, best practices, system, uninstall, windows 2003, cumulative update, downgrade

Cumulative Update 7 available for SQL Server 2005 SP2 - get it now to test and apply (if needed)

Published 15 April 8 3:58 PM | SSQA.net

Here is another candidate of 7 within Cumulative Update service for SQL Server 2005 SP2. SQL Server Release Services team has announced (yesterday) that another instalment of Cumulative Update ( series here ) for SQL Server 2005 on Service Pack 2, it...

Filed under: sql server, microsoft, blogs, download, kba, service pack, cumulative update, downgrade, cu7, affected, releases

Error: 'There is insufficient system memory to run this query' and 'Downgrading backup buffers from 960K to 64K"?

Published 28 March 8 4:31 AM | SSQA.net

Have you ever observed the error specified above? Do you need to worry for this issue, yes! First task to check what are the memory settings on SQL Server, by default they will be DYNAMIC and quite common that they might have set with MIN & MAX settings...

Filed under: sql server, memory, error, update statistics, buffers, memtoleave, downgrade, insufficient