Data Gathering – SQL Server Setup Problems Cindy Gross, Dedicated Support Engineer Gathering the right data during a problem can get you a long ways towards resolving the problem. When you ask the right questions and clearly define the problem it changes the way you approach the remaining...

Using Mount Points with SQL Server Author: Cindy Gross, Dedicated Support Engineer Tech Reviewer: Min He, SQL Cluster PM Summary: Microsoft does NOT support installing or putting databases on the “root” of a mount point in SQL Server 2005, 2008, 2008 R2 unless you manually...

There's a new setup portal to help you out with any SQL Server 2008 or SQL Server 2008 R2 setup issues. You can search for setup content, get downloads, watch videos and more. Learn how to slipstream (new in SQL 2008 SP1) or sysprep (new in R2). Check it out and let us know what you think! SQL Server...

Starting with SQL Server 2008 SP1 you can “slipstream” SP1 and/or SP1 + SP1 based CUs to avoid a multi-step installation process. http://blogs.msdn.com/petersad/archive/2009/04/16/create-a-merged-slipstream-drop-containing-sql-server-2008-server-pack-1-and-a-cumulative-update-cu-based-on-server...

You may receive the error "The cluster either has not been verified or there are errors or failures in the verification report" while installing a SQL Server clustered installation on Windows 2008. When see this error you must fix the underlying error that caused Windows validation to fail. Even though...

The setup files for SQL Server look pretty much the same for all editions. If you saved the files somewhere but didn't indicate in your directory name or a readme file which edition they are for, how do you tell the edition? Running setup doesn't necessarily help, the initial setup screens for SQL Server...

I have copied this over from an older blog . I have cleaned it up a bit to clarify a few areas and added some links. SQL Server 2005 Clustering Tips/References This information will supplement the clustering information I wrote in chapter 10 of SQL Server 2005 Practical Troubleshooting: The...