vSphere 4.1 and SQL 2008 R2

[jfolke]

Hi, I'am looking for a detailed guide how to install SQL 2008/2008R2 for the vCenterserver.

Also if any have experienced ay problems with SQL 2008 R2 in a production enviroment.

Regards

Johann Folkestad

[idle-jam]

Just install MsSQL as per normal on how you would install it normally. Incase you need a tutorial it is here http://www.sqlserverclub.com/essentialguides/how-to-install-sql-server-2008-step-by-step-guide.aspx

Once that is done, you can refer to to the best practices from VMware. http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=102210...

iDLE-jAM | VCP 2, VCP 3 & VCP 4

If you found this or any other answer useful please consider the use of the Helpful or correct buttons to award points

[Snurre_]

Microsoft SQL 2008 R2 databases are planned to be supported from the next release of vSphere, vSphere 4.1 Update 1. The release of this update is planned for the second quarter of this year.

Regards,

Mikael

[arthurvino1]

Looking to deploy SQL 2008 R2 in Vsphere 4.1 as well.

How would ensure High Availability to protect aganist VM failure (blue screen, hung OS, bad drivers, etc)?

[Snurre_]

Hi,

Well you can always use VM monitoring witch is a checkbox in VM Settings. And if you got a good SQL backup solution that will save you in case of a disaster.. It's not the end of the world if you loose your vCenter Server for a while.

Use full VM Backup if you really want to ensure fast recovery time.

Regards,

Micke

--- ursprungligt meddelande ---

Från: "arthurvino1" <communities-emailer@vmware.com>

Ämne: New message: "vSphere 4.1 and SQL 2008 R2"

Datum: 24 juni 2011

Tid: 18.01.29

VMware Communities<http://communities.vmware.com/index.jspa>

vSphere 4.1 and SQL 2008 R2

reply from arthurvino1<http://communities.vmware.com/people/arthurvino1> in VMware vCenter™ Server - View the full discussion<http://communities.vmware.com/message/1778749#1778749