SQL Server Clustering 2000 Vs. 2005
Jan 18, 2007
I am getting ready to have a SQL Server failover cluster setup. I have used SQL 2000 for years, mostly for DTS and related database activities, but NOT in a cluster. I have used SQL 2005 for about one year but not intensively, and NOT in a cluster.
We need to set up a cluster. We are setting up a DELL EMC solution. I am going to hire a consultant to set it up, including the SQL part. My questions are should I use SQL 2000 or 2005? (I don't know if one is better than the other for clustering. Both are supported by our vendor for the application we are running.) How hard is it to maintain a cluster if one hasn't had experience in that area before? How should I prepare?
Any opinions or experiences that you would like to share would be helpful.
Thank you.
View 1 Replies
ADVERTISEMENT
Mar 1, 2006
Hello,
Can anyone give me a site that shows Clustering on SQL Server 2000 step by step. I am trying to have two or more servers acting as one and to get high-availability without having any impact on the application side.
View 2 Replies
View Related
Jan 21, 2004
Environment:
SQL Server 2000 SP3a on W2K Advanced Server SP4.
1 IBM Server x440 with FastT700 Storage (Fibre Channel)
We need to buy another IBM Server x440 or x445 and we would like to make a cluster.
Question 1:
Once we build the Cluster with the installation of the Cluster Service, making the W2K Cluster, is it possible to upgrade the default instance of SQL Server to a default clusterd instance of SQL Server?
In BOL I have found a note that explain how to do this but I have some doubts.
When I installed SQL Server I placed the system files on the C: drive, the DB files on our SAN on disk E: and the log files on disk F:.
Question 2:
If we would like to use Windows Server 2003 what would be the possibility for an upgrade?
I mean, should I erase all and start with Windows Server 2003 setup or can you suggest to upgrade the OS first, from W2K Advanced Server, and then cluster SQL Server if possible?
Can you advice please?
Any help is really appreciated.
Thank you very much for your time.
Franco
View 4 Replies
View Related
Aug 2, 2001
If we have a stateful connection (RDS) and the database fails how will the application reconnect. I do not believe that our application was written using MSCS API. Therefore I don't believe that it caches the user logon and password to log back into the session. So, my question is can the application work with sql server clustering since it uses stateful connections? Any help would be greatly appreciated. Thanks
View 1 Replies
View Related
Nov 28, 2006
We are looking at clustering of SQL Server 2000 [standard Edition] using third party software, any inputs in this regard would be of great help
View 1 Replies
View Related
Dec 11, 2006
We
are looking for clustering of SQL Server 2000 [standard Edition] using
third party software, any inputs in this regard would be of great help
View 3 Replies
View Related
Aug 24, 2006
Hi,
Would anyone give me some directions on where I could get good information on Windows 2003 and SQL 2005 clustering??
Thanks in advance.
View 3 Replies
View Related
Aug 6, 2007
Hi,
Please tell me that,
What is Clustering in SQL SERVER 2005 Database?
What is the main reason of Clustering in SQL SERVER 2005 Database?
What are the advantages of Clustering in SQL SERVER 2005 Database?
How can I implement Clustering in SQL SERVER 2005 Database?
waiting for your reply with thanks
T C
View 2 Replies
View Related
Jun 9, 2008
Friends -
I am going to install sql server 2005 clustering on windows 2003 o/s.
i am using active/passive clustering.
On node : 1 i created a shared disk, quorum, volume1, volume 2 under disk management.
my doubt is do i need to do the same thing again on node :2 like (create shared disk, quorum, volume1, volume 2 same as node:1
Please advise on this.
Cheers:)
vsh
View 7 Replies
View Related
Jul 11, 2006
Hi,
Pl clarify how to use SQL server 2005 clustering Algorythm , I want to use the case and nested table concept. Pl let me know what is key column , Input and product with an example
I have table in the following structure
Cust_id
Age
Product
Location
Income
the above mentioned columns are in my tableand i want to perdict which product is mostly likely to sold with other based on age , location and income
Pl clarify and mail me on rajesh.ladda@lntinfotech.com
Thanks in advance
Rajesh Ladda
View 1 Replies
View Related
Jan 10, 2007
Hi,
We have SQL 2005 2 node active-active clustering with 2 instances on each node.(total 4 instances).
Is it possible to apply Service packs to just 1 instance or does it impact all 4 instances on both nodes ?
View 9 Replies
View Related
Sep 28, 2007
I am developing an enterprise class solution using SQL Server 2005 and MS .NET v2 and am tying determine if SQL Server 2005 (which edition and if so how) would be adequate for my proposed solution. Any feedback, tips, comments would be greatly appreciated.
As a background the solution I am developing will be web services based and used by multiple offices around the globe by over 500 users. I have already developed a prototype using a single SQL Server 2005 instance but as this solution is going to be used by offices around the world I want to have an IIS Server and SQL Server 2005 server instance in each office with "links" back to the primary SQL Server 2005 cluster in Australia.
One of my thoughts was to set up replication between the offices that would happen at midnight remote office local time and then set up triggers to update the primary cluster when assoociated data was changed on the remote sites or on the primary cluster. Does anyone know or can anyone suggest alternatives to this strategy?
I effectively need some sort of inter site caching functionality with store and foreward capabilities ...
Thanks
Andrew
View 6 Replies
View Related
Oct 24, 2007
Hello all,
I have tried to install SQL Server 2005 Standard edition with CLUSTERING. I faced a problem and everything rolls back.
TITLE: Microsoft SQL Server 2005 Setup
------------------------------
SQL Server Setup was unable add user domain1xyz to local group domain1IT Security Admin-Group.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29512&EvtType=sqlca%5csqlsecurityca.cpp%40Do_sqlGroupMember%40Do_sqlGroupMember%40x6ba
I have refered to PostI=1659185 posted by Fly and it still won't be able to fix my problem.
I have added LOCAL SERVICE into the local group (SQLServer2005MSFTEUser$AAA$MSSQLSERVER), but it still can't work.
Please can someone help me on this. Thank a lot....
View 6 Replies
View Related
Nov 2, 2006
We want to use sql 2005 failover clustering feature, so that upgrade sql 2000 is necessary. But some of the stored procedures built in 2000 are not working directly in 2005, set the compatibility level to 80 could make them work. In this case, can somebody here tell me if down grade the database level will affect failover clustering running properly? e.g. will data still be synchronized properly? Thanks in advance.
View 3 Replies
View Related
Mar 12, 2002
We are going to implement a SQL 2000 cluster in an active/passive setup. We are going to use multiple instances. What I am confused about is the naming of the virtual server and instances. In the microsoft documentation it states that all instance/virtual names must be unique across all nodes in the cluster. But the client always specifies the same virtual server name when connecting so how can the names be unique across all nodes??
I would have thought that if there was an instance created called inst1 on node A then during the installation that instance name would be replicated to the failover node B. When installing another instance on Node A do you have to specify a different virtual server and instance name on the failover node B??
Please help!!!!!!!
View 4 Replies
View Related
Jul 26, 2001
Should SQL Server 2000 (Enterprise edition) running on a Win2K Advanced Server (Active / Passive) cluster fail-over seamlessly?
We have been assured by our suppliers that current client connections (ODBC using TCP/IP) cannot be maintained during a fail-over. The result is that during a fail-over the client applications crash and users have to restart.
Do we have to modify the client application so that during a fail-over it will attempt to re-establish a connection?
Pointers to any resources for SQL 2000 clustering would be gratefully received (especially any which support the view that fail-over should be seamless).
Many Thanks
Mark
View 3 Replies
View Related
Jan 11, 2004
Howdy,
I have had questions from management about whether SQL 2000 clustering on windows 2000 is any good.
We are looking at spending *quite* a bit of money to implement it, but I want a "from the trenches" opinion of what its like , from the people that actually use it & look after it.
e.g.
DOES IT WORK LIKE IT SHOULD????????
Is it reliable?
Is it resource hungry?
Can I trust it to do what its supposed to do?
All repsonses very welcome. No response too small.
Thanks for your help.
Cheers,
SG.
View 14 Replies
View Related
May 21, 2002
Are there any decent articles,troubleshooting guides,monitoring guides, books out there, which provide information on setting up SQL 2000 on Windows 2000 using clustering.
thanks
View 2 Replies
View Related
Mar 22, 2001
I have 2 Node Cluster with 2000 Advanced.
I have SQL 2000 Enterprise. I am trying to setup a failover cluster (active/passive)
I have tried to follow the Microsoft Documentation that came with the box but whe hey what do u know - cannot get it to work. I cannot understand the lines "install a default instance of SQL that runs on both". What does this mean?? I know what a default instance means but running on Both ???
Does anyone have document that will show me the steps.
thanks in advance.
View 4 Replies
View Related
Aug 18, 2006
Hi
We would like to install Sql 2005 Enterprise Edition (including database engine, reporting service, integration service and analysis service) as a sepearte instance on a server which already has Sql 2000 with reporting services and analysis services. We do not want to disturb the existing sql 2000 setup.
If we do that then what will happen to my earlier sql 2000 reporting service? Will it be upgraded to sql 2005 reporting service? I heard that reporting services are instance unaware application. Where will be the default reporting service database available?
Please help us.
Regards,
Sankar N
View 1 Replies
View Related
Aug 18, 2000
Does anyone have any information or know where I can get information about setting up SQL2000 and Windows2000 clustering? We want to set up 3 SQL 2000 servers on Windows2000 clustering. We cannot find any technical documentation about the 2 together. If you know of any books or sites please let me know.
View 1 Replies
View Related
Jan 15, 2007
We have a client running a 3rd party app on sql 2000 Enterprise on Windows 2003 Advanced attached to a new SAN. They are looking at adding another SQL server and clustering for failover. Anyone done this before. Do you have to reninstall sql server on the original box to do this. This a a heavily used app, so downtime is always an issue.
View 3 Replies
View Related
Jan 11, 2004
Howdy,
Is SQL 2000 clustering on windows 2000 any good ??
We are looking at spending *quite* a bit of money to implement it, but I need opinions of what its like from the people that actually use it & look after it.
e.g.
DOES IT WORK LIKE IT SHOULD????????
Is it reliable?
Is it resource hungry?
Are there lots of bugs?
All repsonses very welcome. No response too small.
Thanks for your help.
Cheers,
SG.
View 6 Replies
View Related
Oct 22, 2007
hi all....active/active. windows 2003 sp2. two nodes. two instances, each on a separate virtual server. my msdtc resource is in the cluster group. when i have the cluster group on one node, the sql instance that is running on the other node can't see DTC. Makes sense since the service is not up, but is this a problem? Seems strange to have a red stop sign on my dtc icon in sql management studio. I suppose I won't be able to run Distributed Transactions on that node, which kinda stinks. Wondering if anyone has seen a workaround.
View 3 Replies
View Related
Mar 27, 2008
Hello,
I am using MS Virtual Server and wanted to configure sql 2005 clustering.
My configurations are:
1. DC
2. Node1
3. Node2
DC, Node1, and Node2 are in the domain.
1. Bring up the DC
2. Bring up the Node1
3. Bring up the Cluster Administrator and started the clustering configuration.
4. I run into serveral errors.
Services won't start:
Error 1067: The process terminated unexpectedly.
Could not start the Cluster Service service on local computer.
Errors on Clustering Config:
The cluster node is down
The node is already a member of a cluster but the cluster services is not running. This node will not be configured at this time
Can someone help and advise.
Thank you.
Edwin
View 1 Replies
View Related
Sep 12, 2006
Hi all,
I am new in clustering setup and I have a MSSQL2005 (Enterprise edition SP1 and Win2003 Enterprise edition) standalone production server and it will be setup with clustering and SAN. How can I setup the clustering? What are the steps?
I have a testing machine to setup new sql clustering which is working fine. I wonder how to setup from a standalone server. Kindly advise. Thanks in advance
View 1 Replies
View Related
Oct 19, 2006
Installing a SQL2005 active/passive cluster for the first time and have an issue/question. When running throught the SQL2005 setup and you have to enter the Virtual Server name, I enter the Virtual name that has been allocated an IP address and up pops a message saying the name already exists. Why is this? Surely the name and IP address have to be in place before running the setup. Slightly confused here.
Any help would be much appreciated.
Thanks
View 1 Replies
View Related
Feb 18, 2008
Dear All,
I am trying to setup clustering for SQL 2005. I initially want to setup a 2 node cluster in Active/Active Configuration.
I am trying to understand the Quorum disk in SQL 2005. As I understand the quorum disk is a shared resource. How is this resource configured? Would I need to have an iSCSI or fibrechannel connection from each of the nodes to the shared disk?
As well, does each node have a separate data drive? Or do all the nodes use only the shared storage?
Thank you.
View 1 Replies
View Related
Jul 8, 2005
My company is planning on using a datacenter for our customers. These are manufacturing plants from which we collect batch and trend data (currently stored in SQL Server)
View 6 Replies
View Related
May 19, 2008
Hi, I am trying to edit some data from a SQL2000-datasource in ASP.NET 2.0 and have a problem with a column that has bit-data and is used for selection. SQL2005 works fine when declaring <SelectParameters> <asp:Parameter DefaultValue="TRUE" Name="APL" Type="boolean" /> </SelectParameters>When running this code with SQL2000, there are no error-msgs, but after editing a record the "APL"-column looses its value of 1 and is set to 0. Looks like an issue with type-conversion, we've hit incompatibilities between SQL200 and 2005 with bit/boolean several times before. So, how is this done correctly with SQL2000? (I've tried setting the Type to "int16" -> err. Also setting Defval="1" gave an err) ThanksMichael
View 2 Replies
View Related
Apr 4, 2008
Hi,
I am trying to set up a SQL 2005 analysis server cluster in our two servers, AS02 and AS04. The server cluster is built up on Majority Node Set (MNS). During the installation of the analysis service, I don't see the available cluster groups. In the cluster admin, the cluster is up and running fine. The MNS cluster has no shared disk, and it has two nodes.
Any thoughts or suggestions? or is it possible to built the SQL 2005 analysis service cluster with MNS?
Thanks.
View 4 Replies
View Related
Nov 13, 2007
We have 2 env. : Testing and Production, both are running Windows 2003 Enterprise Server with SQL Server 2005. The difference is Testing is NOT running Windows cluster but Production do so, what is the best way to transfer a database from testing to production?
We have another systems that both testing and production are running on NON-cluster and we use backup/restore to transfer the database, can it apply in this case.
And I found that there are a tools called DTC, which can transfer all DB objects from one DB to another, is it a best way to transfer between non-cluster and cluster env.?
View 2 Replies
View Related
Jun 15, 2006
I have several SQL 2000 servers I need to setup transactional (non updatable) replication with. The structure is:
SQL Server 2000 as Publisher/Distributor
SQL Server 2005 Standard as Subscriber
The connection is via the Internet with snapshots using FTP.
I setup the first set (2 databases at location A). They work wonderfully. I created the publication and then subscribed using MGMT Studio for 2K5.
II am setting up the same scenario for location B. Here is my problem:
In MGMT Studio I connect to the publisher (SANDRA). I right-click a publication and choose New Subscriptions..., the publication is already selected. I click next - Run each agent at its Subscriber is selected and the only option (this is desired), I click Next
HERE IS THE PROBLEM:
On the Subscriber's screen there are no Subscribers listed. When setting up location A the subscribing server was listed and I could choose a database. The Next button is greyed out and there is no way to create/add one.
I tried setting up the subscription by right-clicking the subcribing server's Replication folder in MGMT Studio but I get the same result (except that I have to authenticate with the publishing server which works fine).
WHAT'S DIFFERENT:
Location A is SQL Server Standard (SP3) running on SBS2K3. It is obviously on a domain and so SQL Server and the SQL Agent are running under domain accounts. Location B is a Windows XP SP2 machine running SQL Server Personal Edition (it actually says Development Edition in the properties window).
The databases are the same strucutre, different data. At location A the firewall is set to allow 1433->*any* and *any*->1433 where *any* is 1024 or higher. On the XP machine the firewall is set to allow port 1433. I don't think this is the issue because I've turned the firewall off on the XP machine and I get the same result.
ANY IDEAS?
View 5 Replies
View Related