Tag Archives: SP

Microsoft SQL Server 2008 R2 Service Pack 2 Released

Microsoft SQL Server 2008 R2 Service Pack 2 has now been released and can be downloaded from the following link:

http://www.microsoft.com/en-us/download/details.aspx?id=30437

Important Note

If you are upgrading from SQL Server 2008 R2 SP1 Cumulative Update 6 to SQL Server 2008 R2 SP2 then you must apply a post-SQL Server 2008 R2 SP2 cumulative update after you upgrade to SQL Server 2008 R2 SP2 to obtain all the fixes.

Cumulative update package 1 for Microsoft SQL Server 2008 R2 Service Pack 2  can be downloaded from the following link and should be installed straight after you have applied Microsoft SQL Server 2008 R2 Service Pack 2

http://support.microsoft.com/kb/2720425

Watchguard XTM 2 Series, XTM 3 Series, XTM 5 Series, XTM 8 Series – Fireware XTM OS 11.5.1 – CSP4 Build # 335367

Watchguard XTM 2 Series, XTM 3 Series, XTM 5 Series, XTM 8 Series – Fireware XTM OS 11.5.1 – CSP4 Build # 335367

11.5.1 – CSP4 Build # 335367 Resolves the following issues:

BUG64669: Resolved a Firebox crash and reboot when using FireCluster.

BUG63793: Improved proxy debug logging when using FireCluster.

BUG63574: Proxy connections fail with logs showing: “failed to create new traffic spec” and “insert_tspec:XX index inuse?

BUG65026: Iked stack trace eip=0x080c4013 caused by Mobile VPN with IPSec connection.

BUG63860: snmpd memory leak

You can request 11.5.1 – CSP4 Build # 335367 from Watchguard Support by logging a support case online, they should then be able to provide an ftp download link and appropriate credentials.

Please note that Watchguard CSP releases are cumulative so you should only need to apply the latest to ensure that you also have any previous fixes.

How to find the version, edition, Service Pack and Cumulative Update Version of Microsoft SQL Server and its associated components

If you want to find out the version and edition of Microsoft SQL Server then please take a look at Microsoft KB 321185 http://support.microsoft.com/kb/321185

This will show you how to find versions for SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Server 2012

SQL Server 2005

Microsoft SQL Server 2005 Cumulative Updates that have been released after SQL Server 2005 – Service Pack 2 http://support.microsoft.com/kb/937137

Microsoft SQL Server 2005 Cumulative Updates that have been released after SQL Server 2005 – Service Pack 3 http://support.microsoft.com/kb/960598

Microsoft SQL Server 2005 Cumulative Updates that have been released after SQL Server 2005 – Service Pack 4 http://support.microsoft.com/kb/2485757

SQL Server 2008

Microsoft SQL Server 2008 Cumulative Updates that have been released since SQL Server 2008 – RTM http://support.microsoft.com/kb/956909

Microsoft SQL Server 2008 Cumulative Updates that have been released after SQL Server 2008 – Service Pack 1 http://support.microsoft.com/kb/970365

Microsoft SQL Server 2008 Cumulative Updates that have been released after SQL Server 2008 – Service Pack 2 http://support.microsoft.com/kb/2402659

Microsoft SQL Server 2008 Cumulative Updates that have been released after SQL Server 2008 – Service Pack 3 http://support.microsoft.com/kb/2629969

SQL Server 2008 R2

Microsoft SQL Server 2008 R2 Cumulative Updates that have been released since SQL Server 2008 R2 – RTM http://support.microsoft.com/kb/981356

Microsoft SQL Server 2008 R2 Cumulative Updates that have been released after SQL Server 2008 R2 – Service Pack 1 http://support.microsoft.com/kb/2567616

Microsoft SQL Server 2008 R2 Cumulative Updates that have been released after SQL Server 2008 R2 – Service Pack 2 http://support.microsoft.com/kb/2730301

SQL Server 2012

Microsoft SQL Server 2012 Cumulative Updates that have been released since SQL Server 2012 – RTM http://support.microsoft.com/kb/2692828

Microsoft SQL Server 2012 Cumulative Updates that have been released since SQL Server 2012 – Service Pack 1

http://support.microsoft.com/kb/2772858

Microsoft Windows 7 – Service Pack 1 and Microsoft Windows Server 2008 R2 Service Pack 1 – How to Easily Free Up Some Disk Space

Have you started to notice that C drive is getting a little full or do you just want to have a spring clean, well you may not realise it but when you installed Service Pack 1 onto your lovely Windows 7 machine or Windows 2008 R2 Server that Microsoft very sensibly backed up all the old system file before replacing them with new ones.

Assuming that you have had Service Pack 1 installed for sometime without issue it may be good to know that you might be able to reclaim some disk space by dumping these obsolete system files.

Simply launch an elevated Command Prompt by right clicking “Command Prompt” and selecting “Run as administrator”.  Once you are in a command prompt simply paste in the following:

DISM /online /Cleanup-Image /SpSuperseded

Be patient with this command as it will need to enumerate a large number of files and could take up to 60 minutes to complete.  Once finished I would recommend a reboot.

Windows 7 and Server 2008 R2 all use an imaging environment to install so with this command we are launching Deployment Image Servicing and Management (DISM) and then telling it to remove any of the superseded service pack files.  If you do not have any files to remove, might be because someone else has already removed them or your computer/server may have already come with Service Pack 1 pre-installed/integrated.  In this instance you will get a message like the one below, you will also get this if you try to run the command a second time after all the old files have already been removed.