2 SQL Servers or 2 machines running SQL which you can cluster?
The question doesn't really make sense, but if you were to cluster then you would need Enterprise Edition of SQL (whatever version you have - 2000 or 2005)
Yes I just checked and looks like running sql 2005 server on each server (total of 2 servers) but no Enterprise edition.. But couldn't I just run Windows 2003 Cluster Administrator if I am not mistaken and let the OS run the clustering service or am I totally off scope here..
thanks again and please let me know if you have a moment
Bit confused where you say "running sql 2005 server on each server". The theory of clustering is that (from what I am guessing on your setup) is that you would have ONE instance of SQL and use clustering to enforce resilliance so it would run on either node, depending on which was active at the time.
Ahhh, so it's my Windows version that is causing the problem
At the OS I am running Windows 2003 Standard SP2, but I have the service Cluster Administrator running.. so you are telling me that this service called Cluster Administrator can not cluster SQL.
Yes have one instance of SQL is what a meant and thanks for clarifying, got caught up in this mess and losing focus ,, hahah, anway so this won't work thru Windows 2003 server using the clustering service mentioned above eh?
As for the Cluster Admin on you standard version server ... I beleive it can connect to other clusters for maintenance and monitoring purposes that are not on your current server.
I meant to give you a star for your responses to me but got caught up in the cluster which btw is working great!!
I did have another inquiry if you care to take a stab at it.. Now that I have a cluster for SQL established and the failover was tested.
Is there a way to copy the sql databases over from one child domain to another ? the other child domain will be similar in that sense that it will have IIS front end web sites and a sql cluster.. I suppose the question evolves to "what can I get away with, if I can copy the sql dbs, mount and attach them to the other child domain? there are namespace dependencies I'm sure and perhaps I am not asking this question in the correct forum, maybe the dba section?
eitherway, thought I'd ask and see what this inquiry returns, again though I appreciate your support and was able to workout the cluster pieces!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.