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

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 2005 SP3, SQL Server 2005 SP2 CUs, or SQL Server 2008 may cause XP SP2 to restart

The executable files included in SQL Server 2005 SP3, SQL Server SP2 CUs (Hotfixes) and SQL Server 2008 have been manifested to include Vista and Windows 2008 information. Due to a bug in Windows XP SP2 without the hotfix or XP SP3 release you may encounter one of the following bugs. We are still evaulating how common…

9

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