SQL Server 2008 Failover Clustering Whitepaper has been published

  Summary: This white paper complements the existing documentation on planning, implementation, and administration of a SQL Server 2008 failover cluster, which can be found in Microsoft SQL Server 2008 Books Online. There are links to relevant existing content throughout the paper, which is intended primarily for a technical audience. This white paper covers failover…

1

SQL Server 2008 Service Pack 1 on Microsoft Update

Starting on April 28th, service pack 1 for SQL Server 2008 will be posted to Microsoft Update. The update will patch any edition or whether the instance is clustered or a stand-alone instance. To obtain the update, you need must opt into Microsoft Update and manually scan for the update. The service pack will not…

2

SQL Server 2008 Service Pack 1 is Released!

The SQL Server 2008 Service Pack that can update any edition can be found here. The Express 2008 SP1 release can be found here. This service pack makes available Slipstream and SP uninstall.    The Slipstream functionality in Service Pack 1 There are 2 different procedures that allows you to patch the original SQL Server…

4

How do I hide command prompt when I launch SQL Server 2008 in quiet mode

I have been asked this question twice today, so I thought I would create a blog on it.  When you embed SQL Server Express 2008 or launch SQL Server 2008 in quiet mode, a command prompt will be displayed that the process is running under. To prevent this command prompt from displaying, you can add…

2

SQL Server 2008 Service Pack (SP) Uninstall

Starting in SQL Server 2008 SP1, uninstall will be supported.  When you install a Service Pack, an entry is added to Add or Remove Programs or Program and Features in Vista and above.  The uninstall wizard is launched through this entry.   Behaviors: Files restored to previous version, for example: You install SQL Server 2008…

4

SQL Server SP3 has compatibility issues on Vista and Windows 2008

SQL Server SP3 shipped with files that have known compatibility issues on Vista and Windows 2008. To resolve, it is suggested that you apply Visual Studio 2005 Service Pack 1, See http://support.microsoft.com/?kbid=960320 for more information.   If you obtain the SQL Server SP3 update through Microsoft Update when available, you may see a Windows dialog mentioning…

1

You encounter an "API call rejected" error when installing SQL Server 2008

There is a known problem with MSI 4.5 that is used by SQL Server 2008 for installing the product. Under some situation the SQL Server 2008 installation will fail with the following error:                “API call rejected – No actions in Context” Usually rerunning the SQL Server 2008 setup will be fine. See the following article on how…

0

How to create a SQL Server 2008 tools only source drop

Several customers have asked how to create a source media drop that only contains the management tools. SQL Server 2005 had a Tools folder, but this was removed in SQL Server 2008 as the source media layout was changed.  The SQL Server 2005 source media layout caused problems when a customer would copy the Servers…

5

Running the SQL Server 2008 QFE/CU installer in unattended mode

The documentation for running the SQL Server 2008 QFE/CU installer in unattended mode is not currently available online. The instructions are included in the updated help chm contained in the packages.  Here is a quick reference on how to run the patch installer in unattended mode: Patch all applicable instances:  {Patch package}.exe /q /action=patch /allinstances…

0