Welcome to SQL Server 2008 Patching

We have posted the first cumulative update for SQL Server 2008 aptly named Cumulative Update 1 (CU1). I thought before you considered installing a patch for SQL Server 2008, you would like to see a tour of what it looks like compared to SQL Server 2005 patch installations. The first thing I did was download…

10

Upgrade for SQL Server 2008 can fail if you have renamed the ‘sa’ account

UPDATE TO THIS POST: We now have a fix for this problem as documented at 968829  FIX: Error message when you try to upgrade aninstance of SQL Server 2005 to SQL Server 2008: “Wait on the DatabaseEngine recovery handle failed. Check the SQL Server error log for potentialcauses” http://support.microsoft.com/default.aspx?scid=kb;EN-US;968829 However, because this is setup, you…

20

SQL Server 2005 Setup Fails in WOW (x86) On Computer With More Than 32 CPUs

  SCENARIO SQL Server fails to install a WOW64 instance (x86) an on a computer with more than 32 CPUs.   During setup you will encounter a SQL Server failed to start message.     SQL Server is attempting to determine the NUMA configuration during startup.   WOW instances are x86 and limited to 32 CPUs but the…

1

SQL Server 2008 Management Tools Basic vs Complete Explained….

A few questions have come up about the differences between the features you can install on SQL Server 2008 called Management Tools – Basic  and Management Tools – Complete. So I thought I’d blog about these to resolve any questions you might have. Related to this are questions I’ve received on what is SQL Server…

7

How to Rebuild System Databases in SQL Server 2008

In SQL Server 2005, we introduced a different method than in previous versions to rebuild system databases (affectionately known as "rebuild master"). You were required to use the setup.exe program with command line switches. This is no different in SQL Server 2008 but the command line switches have changed some and the process behind the…

22

SQL Server 2008 Express, .Net Framework 2.0 SP2, and 3.5 SP1 explained…

Many of you may have read my post about dependencies with Visual Studio 2008 SP1 and the .Net Framework 3.5 SP1 and SQL Server 2008. I have some related information to provide to you about SQL Server 2008 Express. If you are a user of SQL Server 2008 Express, there is some new information you…

8

SQL Server 2008, Visual Studio 2008 SP1, and .Net Framework 3.5 SP1 explained….

PLEASE NOTE: This blog post has been updated from its original posting to clarify other details about installation of SQL Server 2008 and Visual Studio 2008 SP1. I must say that I’m personally proud to see our release of SQL Server 2008. I’ve been involved with the product team on this release since its early…

66

SQL Server 2005 Encounters Exception During Install When System has Odd Number of Processors or Logical Processors Per Core

While attempting to install SQL Server 2005 you may encounter an error familiar to the following and a retry option presented by setup. Faulting application sqlservr.exe, version 2005.90.1399.0, time stamp 0x434f82e9, faulting module sqlservr.exe, version 2005.90.1399.0, time stamp 0x434f82e9, exception code 0xc0000005, fault offset 0x01019027, process id 0xe70, application start time 0x01c8d28679b262eb. There are a…

10

Database compatibility and new features

Have you attempted to execute queries using some of the new keywords and constructs only to see error messages like the following? Msg 321, Level 15, State 1, Line 5 “sql_handle” is not a recognized table hints option. If it is intended as a parameter to a table-valued function, ensure that your database compatibility mode…

3

SQL 2005 Setup Failures

This week I was reviewing Watson setup failure rates and comparing them to cases opened in the same areas with SQL Server support.  Dec 2006 was the highest volume level for SQL Server 2005 RTM and SP1 cases to date. The values were not out of line, in fact encouraging to a reasonable degree.  Many…

1