alen teplitsky (1/19/2011)
we run sql 2005 and windows 2003to add a new drive letter to an instance you have to take the instance down. i believe it's because you had to add it as a dependency to the SQL service.
on a stand alone SQL server you just add a letter
Thanks Alen. All of these are really good useability benefits of using SQL on VMWare... the main drawback seems to be a relatively small decrease in the availabilty as you will lose the ability to control the SQL instance independently from the OS. If you're going for 99.99% availability I don't think you can do it, but if you can tolerate a regular full outage for a maintenance window then the benefits are enormous.