October 5, 2009 at 11:10 pm
Hi,
From the link http://msdn.microsoft.com/en-us/library/ms177447.aspx
It is important to note that if you add any other resources to the SQL Server group, those resources must always have their own unique SQL network name resources and their own SQL IP address resources
So, if I add a "disk resource" called "E drive" to the SQLGroup, then this Disk E resource should have its own unique SQL network name resources and its own SQL IP address resources
Is that correct..Please correct me..
October 6, 2009 at 2:07 am
disk resources shouldn't be added to the SQL Server Group.:-P
SQL Server Group contains, SQL Server services, Agent service, Analysis services (if you have one n place), SSIS etc.
my two cents:-)
October 6, 2009 at 3:29 am
disk resources can be added to the sql group, either approach will work.
just though i would mention, SSIS is not cluster aware. based on the previous post
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
October 6, 2009 at 11:48 am
disk resources shouldn't be added to the SQL Server Group. [Tongue]
SQL Server Group contains, SQL Server services, Agent service, Analysis services (if you have one n place), SSIS etc.
While installaing SQL Server 2005, after selecting the group (SQLGroup), what you select for data file location?
please see the attachment
October 6, 2009 at 2:24 pm
You should select the drive that you have already added under SQLGroup for SQL Server Data Files.
MJ
October 6, 2009 at 2:38 pm
Assuming you are trying to associate SQL Server with the E Drive:
* Add the E Drive to the same resource group as SQL Server
* In the dependencies tab of SQL Server, add the E Drive
With the above, if SQL Server fails over, the E Drive fails over with it. Without the association, the E Drive may not fail over.
Only services (ie SQL Server) needs a name and ip address.
Hope this helps
October 6, 2009 at 11:40 pm
rambilla4 (10/6/2009)
disk resources shouldn't be added to the SQL Server Group. [Tongue]
SQL Server Group contains, SQL Server services, Agent service, Analysis services (if you have one n place), SSIS etc.
While installaing SQL Server 2005, after selecting the group (SQLGroup), what you select for data file location?
please see the attachment
For data file location you can select one drive but not the entire disk resource?
October 7, 2009 at 1:30 am
Are you referring to a high availability dish share? If so, you can have a cluster group with disk, share, DNSName and IP resources.
This will give you something like \\ClusterDNSName\ClusterShare\ etc and will flip between nodes when failover occurs.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply