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 Express

Article ID Article Title Hidden
86903 Description of caching disk controllers in SQL Server
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
231619 How to use the SQLIOSim utility to simulate SQL Server activity on a disk subsystem
234656 Information about using disk drive caches with SQL Server that every database administrator should know
304261 Description of support for network database files in SQL Server
307356 How to understand Merge Replication article processing order
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
315512 Considerations for the "autogrow" and "autoshrink" settings in SQL Server
316898 How to enable SSL encryption for an instance of SQL Server by using Microsoft Management Console
317375 A transaction log grows unexpectedly or becomes full in SQL Server
321185 How to determine the version, edition, and update level of SQL Server and its components
811889 How to troubleshoot the "Cannot generate SSPI context" error message
822499 Naming schema and Fix area descriptions for SQL Server software update packages
823938 How to configure SQL Server to listen on a specific port
833770 Support for SQL Server on iSCSI technology components
897284 Diagnostics in SQL Server help detect stalled and stuck I/O operations
917047 Microsoft SQL Server I/O subsystem requirements for the tempdb 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"
920093 Tuning options for SQL Server when running in high performance workloads
920925 Detours or similar techniques may cause unexpected behaviors with SQL Server
922672 Support policy for untested .NET Framework assemblies in the SQL Server CLR-hosted environment
941232 How to apply a hotfix for SQL Server in a replication topology
942861 "General Network error", "Communication link failure", or "A transport-level error" message when an application connects to SQL Server
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"
955644 Description of the "access check cache bucket count" and "access check cache quota" options that are available in the sp_configure stored procedure
955850 Error message when you try to use the binaries from the SQL Server System CLR Types package (SQLSysClrTypes.msi): "Unable to load DLL 'SqlServerSpatial.dll': This application has failed to start because the application configuration is incorrect"
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
2027770 Understanding the .NET Framework requirements for various versions of SQL Server
2028436 Database operations take a long time to complete, or they trigger errors when the transaction log has numerous virtual log files
2028589 SQL Server reports errors for exceptions, assertions, and hang conditions
2032911 You may encounter problems when installing SQL Server on a domain controller
2033238 Performance and consistency issues when certain modules are loaded into SQL Server address space
2033448 Winsock Layered Service Providers (LSP) may result in network or server stability problems for SQL Server
2033523 Separate database and transaction log files on different drives for optimal performance and disaster recovery
2033590 SQL Server records the date/time of the most recent database consistency check with no errors
2078345 ​The database PAGE_VERIFY CHECKSUM option can help detect database consistency problems with the system I/O path
2091024 SQL Server reports Msg 5144 and 5145 for long or failed autogrow of databases and transaction log files
2091098 ​Windows System Event Log Errors that indicate possible I/O problems can be associated with database inconsistency or performance problems for SQL Server
2137408 SQL Server logs "Msg 833" when I/O delay problems occur
2152734 How to troubleshoot SQL Server database consistency errors