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

Clustering On SQL Server 2000

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

Clustering SQL Server 2000

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

Sql Server 2000 Clustering

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

Clustering Of SQL Server 2000 SE

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

Clustering Of SQL Server 2000(SE)

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

SQL Server 2005 Clustering

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

Clustering In SQL SERVER 2005 Database

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

Installing SQL Server 2005 Clustering

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

How To Use Clustering Algorytm Is SQL Server 2005

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

SQL Server 2005 Clustering And Service Packs

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

SQL Server 2005 Clustering/Replication/Mirroring

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

Fail To Install SQL Server 2005 (Clustering): SQL Server Setup Was Unable Add User

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

Will SQL Server 2005 Failover Clustering Still Work When The Database Level Is Set To 80?

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

SQL 2000 Clustering

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

SQL 2000 Clustering

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

Is SQL 2000 Clustering Cr*p????

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

SQL 2000 Clustering Information

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

Clustering & Installation With SQL 2000

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

Install Sql 2005 Instance With Reporting Service 2005 On Sql 2000 With RS 2000 Server

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

SQL2000 And Windows 2000 Clustering

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

Clustering An Existing Instance Of Sql 2000

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

Does SQL 2000 Clustering Work Properly??

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

SQL 2005 Clustering And MSDTC

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

Sql 2005 Clustering Problems

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

MSSQL 2005 Clustering Setup

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

SQL 2005 Clustering Setup Question

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

Quorum Disk - Clustering SQL 2005

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

Load Balance Clustering On 2005?

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

Bit-data From SQL Server 2000 (2005 Working, 2000 Doesn't)

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

SQL 2005 Analysis Service Clustering And Majority Node Set

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

Transfer A Database From Non-clustering To Clustering Env.

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

SQL 2000 To SQL 2005 Works For One 2000 Server But Not The Next

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







Copyrights 2005-15 www.BigResource.com, All rights reserved