November 5, 2009 at 11:52 am
I have been tasked with installing an Active/Active SQL 2005 Cluster in Win2008. I know, I should go with SQL 2008 but I have been over ruled due to apps not being SQL 2008 compliant. I have never installed Active/Active on or SQL 2005 in a cluster. Are there any gotchas that I should be prepared for? I have heard that the local C drive needs to have much more space in SQL 2005 than in 2000. We are thinking of having 4 SQL instances. Any suggestions on the size of the C drive? We have heard that Win2008 has a much bigger footprint than Win2003 too.
November 5, 2009 at 1:03 pm
As far as the C drive size. I think we went from 8GB sizes to 16Gb sizes and this has been suffficent. However we usually install all sql related files on another partition. Even with that, there is a portion of the install that still goes to the c: drive regardless. The only gotch I ran into with win 2008 was with firewall policies. By default once you install SQL no one outside of the server will be able to access it unless you address the firewall policies in WIN2k8 so you may want to do some reading on that. There was an article out there that tells you what ports to open for the services you are going to use.
Mike
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply