Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Articles for product: SQL Server 2008 R2 Datacenter

Article ID Article Title Hidden
86903 Description of caching disk controllers in SQL Server
196909 How to increase the number of SQL Server error logs
224071 Troubleshooting SQL Server backup and restore operations
230785 Description of logging and data storage algorithms that extend data reliability in SQL Server
231347 Description of support for SQL Server databases on compressed volumes
234656 Information about using disk drive caches with SQL Server that every database administrator should know
294209 How to rebuild or move a MSDTC installation to be used with a SQL failover cluster
304261 Description of support for network database files in SQL Server
307356 How to understand Merge Replication article processing order
307487 How to shrink the tempdb database in SQL Server
307864 Error message when you connect to an instance of SQL Server: "Cannot open user default database"
310834 Description of common causes of SQL Server error message 844 or error message 845
316898 How to enable SSL encryption for an instance of SQL Server by using Microsoft Management Console
321185 How to determine the version, edition, and update level of SQL Server and its components
327518 The Microsoft Support Policy for Clustered Configurations of SQL Server with Windows Server
811889 How to troubleshoot the "Cannot generate SSPI context" error message
822499 Naming schema and Fix area descriptions for SQL Server software update packages
833770 Support for SQL Server on iSCSI technology components
835185 Microsoft Windows Failover cluster resource dependencies in SQL Server
897284 Diagnostics in SQL Server help detect stalled and stuck I/O operations
903643 The Ntbackup.exe operation may break the differential backup chain of a SQL Server database and may invalidate the differential backups when you perform a snapshot backup of the database
917825 How to use the Sqldumper.exe utility to generate a dump file in SQL Server
919155 Error message when you run the DBCC CHECKDB statement on a database that contains one or more very large tables in SQL Server: "Timeout occurred while waiting for latch"
920925 Detours or similar techniques may cause unexpected behaviors with SQL Server
926150 Using database mirroring for cross-database transactions or distributed transactions is not supported in SQL Server
926930 Hard disk drive sector-size support boundaries in SQL Server
942861 "General Network error", "Communication link failure", or "A transport-level error" message when an application connects to SQL Server
944837 Description of the Replay Markup Language (RML) Utilities for SQL Server
945934 How to register Microsoft Filter Pack IFilters with SQL Server
949080 Error message when you execute a CLR routine or use an assembly in SQL Server: "Assembly in host store has a different signature than assembly in GAC. (Exception from HRESULT: 0x80131050)"
955392 How to update or slipstream an installation of SQL Server 2008
955499 How to uninstall an instance of SQL Server 2008
955626 Error message when you try to run the Sqlmaint Utility after you upgrade to SQL Server 2008 or a later version: "The SQLDMO 'Application' object failed to initialize"
956032 Error message when you run the Distribution Agent in SQL Server 2008 or in SQL Server 2008 R2: "The distribution agent failed to create temporary files"
956176 Error message when you try to save a table in SQL Server: "Saving changes is not permitted"
956893 Support policy for Microsoft SQL Server products that are running in a hardware virtualization environment
967576 Microsoft SQL Server Database Engine Input/Output requirements
969052 How to restore the missing Windows Installer cache files and resolve problems that occur during a SQL Server update
969962 Various memory errors are logged to SQL Server error log when using SQL CLR objects
980499 English Setup pages are displayed when you run the SQL Server 2008 R2 Setup program for another language
981592 Configuration options are missing on the SharePoint Central Administration Web site
982360 SQL Server 2008 Management Studio functions incorrectly after you install SQL Server 2008 R2 Analysis Services
2002606 OS errors 1450 and 665 are reported for database data files
2027537 Best Practice recommendations for SQL Server Database Backups
2027550 Recommended MSDTC settings for using Distributed Transactions in SQL Server
2027770 Understanding the .NET Framework requirements for various versions of SQL Server
2028324 How to troubleshoot SQL Server error message 17890
2028433 How to troubleshoot SQL Server error 17112
2028436 Database operations take a long time to complete, or they trigger errors when the transaction log has numerous virtual log files
2028443 How to troubleshoot Event ID 12 with source Microsoft-Windows-HAL