MS Clustering(Urgent)

May 29, 2002

Hello,

I've clustering set up for my production server, My question is when Active sever goes down the Passive server comes up. But what happens when one database gets corrupted does the clustering take place or I've to work with restore.

Thanks for your help

Rea

View 1 Replies


ADVERTISEMENT

Error : 18452 In Clustering; Very Urgent

Oct 21, 2005

We have 2 failover servers and one client in our test environment. We have all the three configured in mixed mode authentication(windows + sql server authentication). But when we are failing over from 1st server to 2nd one, we are getting the following error message,

View 3 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

Timeout Expired -- URGENT, URGENT, URGENT!!!

Sep 27, 2000

This morning I can not connect to our SQL Server 7.0 whatever from client or server. The error message which I list below:

++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++
A connection could not be estabished to server--Timeout expired
Please verfy SQL Server is running and check your SQL Server registration properties and try again.
++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++

We use windows NT authentication. We did not do any change on NT. The SQL Server daily schedule job usally stoped at 10:00AM, but today from the Window NT Task Manager, we can see that the SQL Server is still running untill now.

Please help!!!

View 3 Replies View Related

URGENT.Sql Server Does Not Recognise MAPI , Or Profile Name URGENT

Oct 26, 2000

hi, I have settup up sql mail and did the following:
1. created an E-mail account and configured Out look by creating a pop3 mail profile. tested it by sending and receiving mail, that is ook
2. I Created one domain account for MSsqlserver and Sql Agent service. both services use same account and start automatically in the control panel-services
3. I used the profile that I created in outlook to test the sql mail but got an error:
Error 22030 : A MAPI error ( error number:273) occurred: MapiLogon Ex Failed due to MAPI
Error 273: MAPI Logon Failed

I really do not know what went wrong. I followed the steps from bol and still having a problem. Am I missing something.

I do have a valid email account
I do have a valid domain account
I tested outlook using the email account and it worked. so why sql server does not recognise MAPI.

My next question, How to configure MAPI in Sql server if what I did was wrong.

View 1 Replies View Related

Urgent, Urgent !! My Sql Server Refused To Start Due To Encrypton

Mar 23, 2001

Hi, I have 2 windows 2000 server in cluster with sql server 2000 enterprise edition installed.
I have activated the Server-Requested Encryption by using the sql server network utility (Force Protocol Encryption). After this, I have stoped sql server service. But I can't start it at this moment.
The error is:
19015: The encrypton is required but no available certificat has been found.

Please help me to start sql server.

Thanks.

Michel

View 4 Replies View Related

Urgent Urgent Please.(Access SQL Pass Through Queries)

Jul 6, 2000

Hello,
I am facing a huge problem in my sql server database using access as a front end.The main problem is trying to execute queries "views" ,since they reside on sql server now,and using variables or parameters in reports and forms to filter on this query.
Ex.
how can the following be implemented using the same query but in sql server?
Access
------
SELECT MAT_Charts.YYYYMM
FROM MAT_Charts
WHERE ((([Area_Code] & "-" & [GROUP_CODE])=[Reports]![MAT_Chart_C1].[MAT_Key]))
GROUP BY MAT_Charts.YYYYMM;

It is specifically this statement in which I am interested:
[GROUP_CODE])=[Reports]![MAT_Chart_C1].[MAT_Key]))

Thank you very much for your concern.

View 2 Replies View Related

Clustering

Dec 4, 2000

What is clustering?Why is it done?
Any suggestion appreciated.
Cheers!

View 4 Replies View Related

SQL 7 Clustering

Sep 14, 1999

I need to cluster two NT Enterrpise Servers with SQL 7 running on them. I have been looking all over the Net for info but not much luck. I need to have some specifics. Can you help me with some good sites or books or both? I have tried Microsoft and they had some info but not much.

Please help!

thanks

View 3 Replies View Related

SQL Clustering-NT Vs W2K?

Nov 20, 2001

We are in the process of consolidating all our SQL6.5 and SQL7 databases to a single SQL 7 server - once completed we want to setup a 2 node SQL7/2000 cluster on either NT4 Enterprise or W2k Advanced Server. I would therefore appreciate any advice in choosing between the two platforms based on cost, ease of setup & configuration and ongoing reliabilty & uptime etc - we currently have no NT4 Enterprise Servers so would have to purchase these licenses anyway. Correct me if I am wrong but I also understand that setting up a cluster on NT4 Enterprise is considerabely more complicated and time consuming than on W2K Advanced Server? Any advice would be greatly appreciated..

regards
Marcfw

View 1 Replies View Related

SQl Clustering

Oct 13, 2005

I have a job interview and I need to know what type of questions can be asked about working in a cluster environment, I don't have much experience in clustering, can someone please give me an idea?

Thanks in advance!!

View 5 Replies View Related

Clustering

Mar 19, 2001

Can I implement failover clustering between SQL Server 2000 & SQL Server 7.0? Or do they both need to be the same version of SQL Server.

View 3 Replies View Related

Clustering

Feb 14, 2005

I have a question relating more to documentation and support. I'm trying to find documentation on clustering.

I remember quite some time ago I found a white paper that literally walked you through every step involved in setting up a SQL Server failover cluster. I had also found a white paper that walked you through setting up an Active/Active cluster.

I've been going through Microsoft's site, but all I've found are little bits and pieces.

If anyone can point me in the right direction, or even provide a link, etc. as to where to find some good solid documentation, that would be awesome.

Thanks!!

Anthony

View 2 Replies View Related

Clustering

Sep 21, 2005

If i have an activepassive cluster for SQL Server, under what circumstances would it prompt to automatic changeover to the passive cluster ? Failure of the SQL Server, or let's say 1 user database out of 25 becomes suspect?

View 1 Replies View Related

Clustering

Sep 21, 2007

Is this possible with Express Edition.

We have two servers both running SQL 2005 express. Is there anyway that any changes on one could be replicated on the other?

Thanks

View 17 Replies View Related

Clustering SQL

Jun 6, 2007

HiI would like to know if it's possible to make a basic SQL cluster withwindows 2003 server and SQL 2000 standard edtition. It has to be abasic cluster, I dont need it to be very quick, I can have minutes ofservers down and it's ok.In case the answer is Yes, can you recommend some links to build itup, please?Thanks in advance!!Ignacio

View 2 Replies View Related

Clustering

Jan 7, 2008

what is clustering tell me in detail

View 4 Replies View Related

SQL N + 1 Clustering

Mar 4, 2008



We currently have a cluster configuration that is running as failover with one shared SAN storage solution. Two servers running Windows Server 2003 Enterprise and SQL 2005 Enterprise. We have two nodes right now running in failover and we will be purchasing a third.

Everything is working now, but we would like to move to an N+1 configuration with two active nodes hosting a separate SQL instance each with one failover node. I've seen N+1 mentioned on about a dozen Microsoft websites, but I cant find any documentation on how to setup or configure this clustering method. Has anyone ever set up a configuration like this or seen any documentation on how to do it? Is it possible to run failover with three nodes, two of them being active?

Any insight would be greatly appreciated.

View 5 Replies View Related

Clustering

Jul 20, 2006

Hi,



Where can I post issues with SQL 2005 clustering. Is there any prereq that needs to be followed before installing SQL 2005 on a windows cluster?



Thanks

View 14 Replies View Related

Clustering Vs. Log Shipping

Dec 4, 2006

Hi All,
Is anyone can tell me the difference between log shipping and clustering? I look at it and I think that this is the same thing as they use two different servers.
TIA

View 5 Replies View Related

Clustering Questions

Jul 24, 2000

Does anyone know the answers to either of these, given that we are talking about an active/passive cluster using MSCS, and we use Groupwise for mail (don't ask!)?

1) How do I configure Agent Mail on the cluster under this setup?

2) How do I set up linked servers from this setup to other (non-clustered) SQL servers - I can set up the cluster virtual server as a linked server from the others OK, but the other way around doesn't work - perhaps not surprisingly, but is there a way around it?

Thanks

Martin

View 1 Replies View Related

Clustering Sql7

Aug 11, 2000

I need some documentation on how to trouble shoot clustering SQL7EE. I have setup the cluster and looks like it is working but I missed somthing. When I test a failover by pulling the Network cable to the main network not the heartbeat network both boxes lock up. I can failover by powering down one box and using the MSCluster Admin. I am using NT40 6a on Dell PowerEdge 2400 and PowerValut 211s

View 3 Replies View Related

Clustering With NT/SQL Server

May 1, 2000

Is any doing any using Microsoft's Clustering technology as a failover
system with NT/SQL Server ?

View 1 Replies View Related

Clustering With NT/SQL Server

May 1, 2000

Those of you who are using MS Clustering, what are some advantages vs. a third party product such as "Double-Take" ? If you have used "Doube-Take" I would be extremely interested in your thought of the product.

Is it relatively easy to setup and configure with and environment
that's using all the standard products of BACKOFFICE (SQL Server 7.0 Standard Edition, NT 4.0 Standard Edition etc...)

Any hints, tips, etc... would be also GREATLY appreciated.

Thanks in advance.

View 2 Replies View Related

SQL Server Clustering

Jan 28, 2000

I have a question about database clustering. I am loking for the solution for the databse scalability, performance and zero downtime especially for MS SQL Server. As my understanding (correct if I am wrong), only Oracle provides 2 DB Servers (parallel server) or NT clustering for two sql servers. The drawback for these solution is only one server is working and another one is standing by. It is not efficent (which only 50%). Is any way that I could built the DB server farm which every DB server is working, if one failed, throw it away, rest of them still working; if I need more power, just add another db server box.How to solve the data sync problem ? Replication is not good for more than 4 or 5 db servers in the farm. Disk mirror is not good since if the server is down, there is no way to access the disks. DO you have any good idea ?

View 2 Replies View Related

SQLSERVER Clustering

Jan 24, 2001

Hi Guys,

I am installing sqlserver 7.0 in cluster server.
When I start with Installing the MSDTC and give the IP Address
of the Virtual server, It is giving message:

IP Address is in use.

I couldn't able to continue the installation further

Kindly advice me asap.

Thanks in advance,
Anu

View 5 Replies View Related

Clustering SQL Questions

Sep 7, 1999

2 Clustering Questions for you.

1. If I cluster 2 SQL servers in an active/active configuration and want to have a seperate disk array to house the data, do I need to have 2 disk arrays, one per server, or can I have one disk array?

2. When installing an application's database on the first(primary) sql server in an active/active configuration, do I need to install it on the second(secondary) server also? The second server will pick up the processes if the first fails.

View 2 Replies View Related

Clustering SQL Server 7.0

Aug 24, 2000

Hello,

How do i can configure sql server Cluster in mode Failover Active-Active?
Is possible?

Please help me

Thanks

View 2 Replies View Related

Requirements For Clustering

Jun 17, 2005

For SQL 2000, what are the licensing requirements for a clustered environment? I thought you needed datacenter for the OS, is there a clustered version of sql server, or do you need 2 copies of enterprise edition. Also, if you cluster can you license sql cals for clients, or do you have to do by processor?

View 4 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

SQL Server Clustering

Nov 8, 2006

In a clustered sql server environment having two Nodes, configured as Active/Active or Active/Passive, do I need to create the databases on both the Nodes?
I am not too sure about how to create databases in the clustered environment. Can somebody help..

View 1 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







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