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 Enterprise

Article ID Article Title Hidden
2029023 Guidelines on Securing folders for Database Files and Program Files of a SQL Server Installation
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
2152472 How to troubleshoot SQL Server Errors that prevent a successful database startup or recovery
2152734 How to troubleshoot SQL Server database consistency errors
2154845 Recommendations to reduce allocation contention in SQL Server tempdb database
2157114 The 'affinity mask' and 'affinity I/O mask' configuration should not conflict
2157129 Changing the 'max worker threads' configuration of SQL Server
2157154 The 'Blocked Process Threshold' configuration does not work as expected for values less than 5
2157198 32-bit SQL Server failover clustering is not supported on 64-bit versions of Windows
2160663 Recommendations and guidelines for setting the AUTO_SHRINK database option in SQL Server
2160685 Recommendations and guidelines for setting the AUTO_CLOSE database option in SQL Server
2199576 How to troubleshoot SQL Server lock related problems and errors
2199578 How to manage the SQL Server error log
2216456 SQL Server 2008 Service Pack 2 and SQL Server 2008 R2 Service Pack 2 enhancements to the "Operation has been cancelled" error message text in Analysis Services
2252955 Considerations when using the SQL Server Full-Text search engine for the Japanese language
2270849 Error 0x80040e97 occurs when you use integrated full-text search in SQL Server
2280126 SQL Server 2008 full-text query may return false positives using number with more than 9 digits as search predicate condition
2292737 Rebuilding an index can result in fragmented index when ALLOW_PAGE_LOCKS option is not enabled
2295405 SQL Server service crashes when you run an Oracle linked server query
2310152 Oracle publication triggers sends data for non-published columns when replicating with Microsoft SQL Server
2402659 The SQL Server 2008 builds that were released after SQL Server 2008 Service Pack 2 was released
2407439 You may notice an increased transaction log sizes in SQL Server 2008 and later versions when you perform Index Maintenance
2416767 You may get an error message when trying to load or save a SSIS package
2420359 Error message when you install SQL Server 2008 RTM on a localized (non-English) Windows Server 2003 version: "SQLBrowser start request failed"
2429685 Cannot connect to a named instance of a clustered analysis services
2443455 You may experience connectivity issues if SQL Server service account delegation settings are misconfigured
2443457 You may experience connectivity issues to SQL Server if SPNs are misconfigured
2443518 Limited support options might be available for certain versions of SQL Server
2446955 SSIS package may encounter an error 0xC0014100 on a computer that is running Windows Server 2008 or Windows Vista
2454053 Use of system filter drivers can lead to SQL Server Database Engine performance degradation and consistency problems
2470176 Applications may fail after upgrading your database from SQL Server 2000 to a later version
2481773 You get "Error code 64" when accessing Replisapi.dll through ISA server
2483962 [SDP 3][5da7d6cb-35c7-4eec-b453-04cceaa24307] SQL Server General Data Collection Diagnostic for Windows 7 and Windows Server 2008 R2
2490051 Mirrored databases are disconnected after you restart the database mirror in SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2
2494094 MS11-049: Description of the security update for SQL Server 2008 Service Pack 2 QFE: June 14, 2011
2494271 You cannot eject a tape by using a tape device button after you run a SQL Server 2008-based maintenance plan that backs up databases onto the tape device
2496344 SQL Server Installation Center may display English content on a localized version of SQL Server after you apply a cumulative update
2508239 An AFTER INSERT trigger may not work correctly after you apply the fix documented in 975950
2519834 SQL Server reports "Operating system error 1117 (I/O Device Error)" on VMware ESX environments that are configured to use PVSCSI adapters
2520691 Updating a view via Linked server query may fail
2523164 SQL Server configuration changes may not be installed because they have not been reconfigured or SQL Server has not been restarted
2523744 The transaction log may grow without a log backup for a database using the FULL recovery model