Home Sitemap Feedback About... Print
Custom Search

SQL Server troubleshooting


Planning

Product overviews, feature lists

SQL Server 2008

SQL Server 2005

Books Online

  • Books Online - the complete documentation set for SQL Server 2005
  • 913392 - Error message when you open SQL Server 2005 Books Online: "Microsoft Document Explorer cannot be shown because the specified help collection 'ms-help://MS.SQLCC.v9' is invalid"
  • Download the latest version of Books Online
  • Try out the new Books Online scoped search functionality

Upgrading tools and information

A fresh installation, followed by a transfer of your databases is the recommended way of upgrading your SQL server installation. If that is not an option, you can perform an in-place upgrade.

SQL 2008

SQL 2005

ServicePacks and Update information and downloads

SQL 2008

  • 958186 - Cumulative update package 2 for SQL Server 2008
  • 956909 - The SQL Server 2008 builds that were released after SQL Server 2008 was released

SQL 2005

General info, system requirements, supported configurations

  • 935897 - An Incremental Servicing Model is available from the SQL Server team to deliver hotfixes for reported problems
  • Hardware and Software Requirements for Installing SQL Server 2005
  • 956893 - Support policy for Microsoft SQL Server products that are running on a virtual machine in a Windows Server 2008 Hyper-V environment
  • 822400 - Description of disaster recovery options for Microsoft SQL Server
  • 327518 - The Microsoft SQL Server support policy for Microsoft Clustering
  • 254321 - Clustered SQL Server do's, don'ts, and basic warnings
  • 835185 - Failover cluster resource dependencies in SQL Server
  • 945936 - The DHCP support is not available when you install SQL Server 2005 on a Windows Server 2008 failover cluster
  • 942176 - Description of the SQL Server Integration Services (SSIS) service and of alternatives to clustering the SSIS service
  • 819546 - SQL Server 2000 and SQL Server 2005 support for mounted volumes
  • 922664 - SQL Server is not supported on Intel-based Apple Macintosh computers that run a Windows operating system
  • 906649 - Unsupported tuning options for some editions of SQL Server 2000 and of SQL Server 2005
  • 329526 - File allocation extension in SQL Server 2000 (64-bit) and SQL Server 2005
  • 926930 - Hard disk drive sector-size support boundaries in SQL Server 2005
  • 304261 - Description of support for network database files in SQL Server
  • 919023 - SQL Server 2005 connectivity and Volume Shadow Copy Service (VSS)
  • 907741 - Issues to consider when you use the database mirroring feature in SQL Server 2005
  • 926150 - Using database mirroring for cross-database transactions or distributed transactions is not supported in SQL Server 2005
  • 910716 - Requirements for SQL Server 2005 and SQL Server 2000 to support remote mirroring of user databases
  • 907557 - The supported Windows account types that you can use to run the SQL Server Agent service in SQL Server 2005
  • 910378 - Scalable shared databases are supported by SQL Server 2005
  • 905006 - Description of the type mapping of the new SQL Server 2005 data types in the OLE DB Provider for SQL Server (SQLOLEDB) and SQL Native Client
  • 944837 - Description of the Replay Markup Language (RML) Utilities for SQL Server
  • 909392 - OLAP assemblies and binary files that Microsoft supports for programmability in SQL Server Analysis Services 2005
  • 956208 - Description of cross-version compatibility scenarios for merge replication in SQL Server Compact 3.5
  • 956601 - Description of the blocking monitor thread in SQL Server 2005
  • 309422 - Guidelines for choosing antivirus software to run on the computers that are running SQL Server

Support webcasts