Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 08-07-2009
Member
 
Join Date: Jun 2009
Posts: 39
SQL 2008 clustering with Windows 2008

Hello
I have question for you guys,am not much in to SQL clustering.just curious to know SQL 2008 clustering remain the same as SQL 2005 in terms of it's functionality.Searching for any best idea for configuring the SQL clustering.

got only the guide in order to configure a two-node Fileserver Failover cluster. can i follow the same for SQL database setup
any thoughts?

thanks.!!
Reply With Quote
  #2  
Old 08-07-2009
Member
 
Join Date: May 2008
Posts: 4,565
Re: SQL 2008 clustering with Windows 2008

Microsoft varied the design to a certain levels.in the first level it will search for whether you machine is compatible with the setup.if it fails then you can't proceed so it should support clustering.mean while the r hardware must be on
Windows Catalog for Clustering and purchased/configured as a cluster.

any way best of luck.!!
Reply With Quote
  #3  
Old 08-07-2009
Member
 
Join Date: Apr 2008
Posts: 4,086
Re: SQL 2008 clustering with Windows 2008

What i have done is that installed Windows Server 2008 enterprise also added the Hyper-V role and then restarted
W2K8DC is a domain controller with a side serving of ISCSI, so possibly you want two networks,make node 2 just like you create the previous node
now you are able to recover in SQL Server and it will fine for you. you have the software you need and the knowledge base to use it in brilliant way
Reply With Quote
  #4  
Old 08-07-2009
Member
 
Join Date: Jan 2008
Posts: 3,751
Re: SQL 2008 clustering with Windows 2008

For me it sounds like problem is not that the quorum requires a lot of I/O, it is that it must respond to I/O requests quickly.From the SQL online, it recommends the quorum disk should be at least 500 MB I would use the log drives for the quorum slice, mainly because most of the log activity is write while the quorum checks are mostly reads.since our cluster and the production db's are all located in a single location, in fact in a single SAN, there is no distributed transactions and therefor I don't think we need MSDTC.SSIS and some workstation tools require DTC because it is how SQL and
non-SQL transactions work together.
Reply With Quote
  #5  
Old 20-07-2009
Michael Tomrow
 
Posts: n/a
Re: SQL 2008 clustering with Windows 2008

Hi there

Well I’m no to sure if it is still similar, but may recommend you a very good page that has a lot of guides about the topic, I’m berry confident that you will founded interesting.
http://www.starwindsoftware.com/technical-papers
Best of luck
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "SQL 2008 clustering with Windows 2008"
Thread Thread Starter Forum Replies Last Post
Difference between Windows Server 2008 / SBS 2008 / EBS 2008 / SBS2003 kyosang Small Business Server 1 06-05-2009 09:09 PM
how to uninstall windows 2008 failover clustering tc Windows Server Help 2 13-02-2009 10:41 PM
Windows Server 2008 Failover Clustering WMI provider, causing WMI queries to fail Viensterrr Operating Systems 2 12-12-2008 05:52 PM
Clustering Windows 2008 JJP Windows Server Help 4 13-08-2008 03:10 PM


All times are GMT +5.5. The time now is 08:57 AM.