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

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

Using Microsoft Clustering For Database Failover Support

Jun 9, 1999

I am looking in to using Microsoft Clustering supported in NT Server Enterprise to provide failover support for 2 database servers running SQL Server 7. I was wondering if anyone had any experience with it--good or bad. I read the white paper and it sounds good, but I'd like to get some real
world application experience.

Thanks for any info.

Bob

View 2 Replies View Related

DR: Replication Vs. Log Shipping Vs. Clustering Vs. Database Mirroring........

Aug 8, 2006

Up to now we have gotten by without having any local DR copies of servers (if a sql server goes down we are usually able to get it back in less than 3 hours). But I want more now. I want to trim the "down" window to no more than 5 or 10 minutes. (Immedate failover would be nice but is not an essential requirement. The essential requirement is to loose no data!)

I have a spec of knowledge in these areas:

SQL 2005 Clustering (requires approved hardware, quorum disk, etc. involved)

SQL 2005 Replicaiton

SQL 2005 Log Shipping.

SQL 2005 Database mirroring. ( needs three servers)

Which approach do you think is the most straightforward, sparing of hardware, yet reliable way to get us back up and running after a sql server failure.

TIA,

barkingdog

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

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

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

Clustering Is Possible With WindowsXp?

Apr 1, 2008

Dear all,
i've read in a article that clustering and it states that clustering is possible with windows 2003 server only. is it not possible to create cluster (i'm planning for fail over clustering)? if so, is there any software for that?

and one more thing is there any free downloads for eBooks of sql server?

thank you very much

Vinod
Even you learn 1%, Learn it with 100% confidence.

View 1 Replies View Related