Migrating Cluster Instances To Stand Alone Install

Sep 21, 2007

Hello all: looking for some general advice on proper approach. looking to move databases off of a clustered instance to a new (non-clustered) server.
Got several issues i'd like some advice on.

1. This is an OLTP instance that's been around for a while & it's pretty well encrusted with apps & processes that attach to it. Therefore it would be a very good thing if we didn't need to change the connection information in several hundred places after the move.
I've tested one approach to this that seems to work: moved the instance to a server which has the same name as the cluster resource associated with the clustered instance and an instance that has the same name as the clustered instance.
For example: cluster install is aiproddbproduction, moved it to a box called aiproddb with a named instance called "production". There's a bunch of tedious network stuff that has to be done to make this work (binding an IP address to the MAC address of the new box and some murky DHCP reservation fiddling), but after the network crew got done cursing me it did finally work.
Does this seem like a reasonable approach?

2. What's the best way to transfer security info to the new instance? I used the transfer Logins DTS widget but had some problems with it not being able to find some groups in AD.

3. what's the best way to transfer DTS packages?

4. is it necessary for the new instance to be at the same patch level as the old instance? the old clustered instance is still at SP3 and i threw the latest SP4 on the new location. good/bad/indifferent?

5. i was planning on taking a full backup & restoring it to the new machine. Is there a better way? Is the wizard for copying databases a good thing?

Those are these issues i'm aware of and have given some thought to. There are probably things about this i haven't considered and would appreciate some word on.

thanks,
Garth

View 3 Replies


ADVERTISEMENT

Migrating Everything From Stand Alone Box To A Cluster Server.

Mar 3, 2004

Can anyone tell me how to migrate everything from a stand alone sql server to a new clusterd environment?

1. Master
2. Msdb
3. Model
4. Jobs
5. DTS packages
6. Logins etc.

P.S. I need to move everything from stand alone to cluster.

Can any one tell best way for each of these?

Thanks,

View 2 Replies View Related

DTS_E_PRODUCTLEVELTOLOW - Migrating From Stand Alone To Cluster

Dec 27, 2007

I am having the following problems and scenarios.

I am moving all of our SSIS packages from a stand alone server to a clustered environment. The old server ran Enterprise Edition, the new server runs Enterprise Edition 64 bit.

One package on the new server is giving me the error messaage DTS_PRODUCTLEVELTOLOW when run from a job. The package is stored in MSDB

I went back to the server and ran the following with the following results.

- Connected to SSIS from Management Studio on my desktop and ran the package and got the same error message.

- Did the same as above but was connected to the server through Remote Desktop and it ran fine

- Ran the job, which just runs the package and it ran fine


On the new server it won't run in any scenario.



Any ideas on what to do?

Thanks

View 8 Replies View Related

SQL 2012 :: How To Install Cluster On Multiple Instances

Mar 4, 2015

We have 5 instances on our clients old machine with SQL 2005, now they want us to move on cluster environment with SQL 2012.

Once I have installed and configured SQL cluster with single instance, but how to install SQL Cluster environment for Multiple instances.

Should I install all the instances first and than have to configure cluster ?
OR
Is there any way that first I will install cluster and than we can add the instances ?

View 9 Replies View Related

Install Muliti Instances On SQL 2005 Cluster With The Same Server Name

Mar 29, 2007



I am trying to install multi instances on my server cluster 2003 R2 Sp2. Because of the compatibility issues with my services I need to install both SQL 2000 and 2005. With 2000 I can easily specify the instance and servername. The server name can be the same, but the instance has to be different. Is this true for 2005? I have found so far that for every new instance that you create that you need to have a different virtual server name. How can you utilize the same virtual name and have multi insances



servername$instance1

servername$instance2

and so on



ThatGuy

View 1 Replies View Related

How To Install SS2005 On New Nodes In Existing Cluster For Multiple Instances ???

Oct 5, 2007

Hi There

I have found no real documentation on this, so any links would be greatly appreciated.

We have an existing 2 node active active cluster.

A default and and named instance SS2005 Enterprise Edition are installed on the cluster.

Recently we acquired new hardware, 2 servers, which we added to the cluster so we now have a 4 node cluster.

The 2 new nodes have OS etc installed.

Now i have installed sql on a new multi node cluster, i have upgraded sql server in an existing cluster BUT i have never installed sql on an existing cluster for new nodes for multiple instances.

Now i presume you simply run the install on one of the new nodes, do this for a default instance, selecting both 2 new nodes to installl on. And do this again for the named instance.

But in the past I have never been promoted for which nodes to install sql on, it simply does all the nodes BUT i do not want this.

And how will the cluster know where the binary files are for each instance on the new nodes?

In a nutshell, how do i install sql server 2005 for 2 new nodes in an existing 4 node cluster for multiple instances ?

Thanx

View 5 Replies View Related

SQL 2005 Stand Alone To Cluster

Feb 11, 2007

Our production server is currently running SQL 2005 on a stand alone machine. SQL Server is installed as a default instance. 

 Can we upgrade to a cluster without having to change the instance name i.e currently applications connect to this server with hostname of the server i.e SERVERA, can we install a cluster such that sql server can still be called SERVERA.

 

 

View 6 Replies View Related

Move Instance From Cluster To Stand Alone?

Aug 14, 2015

I have a SQL 2008 R2 2 node cluster.  For DR testing, I need to restore an instance on a new server (completely isolated).  The existing instance runs on what I would call an alias.  The actual cluster host name is SQLPROD (cluster nodes are SQL01 and SQL02).  The instance runs on server SQLPROD-APPLE.  The instance is called APPLE.  In production, I use SQL Management Studio and I connect to SQLPROD-APPLEAPPLE.

I've setup a new VM to run SQL.  Not a cluster.  Host name is SQLREC.  The new Vm has all the IP addresses that were on the cluster and the DNS for all the aliases are correct.  I've installed instance APPLE.  I created an alias called SQLPROD-APPLE.  When I try to open SQL Management Studio and connect, I can't connect to SQLPROD-APPLEAPPLE.  I can connect to localhostAPPLE, SQLRECAPPLE, 192.168.168.50APPLE.

When I attempt to connect to the alias I get error 18452.  Pinging the alias resolves correctly.  I haven't gotten to the database restore yet, so that's not a concern.  I'm just trying to validate the connection first with the correct server and instance names.

I'm using Windows Authentication.

View 9 Replies View Related

Migrating Jobs To Cluster Server..

Mar 3, 2004

Can anyone let me know how to migrate the sql server jobs to new cluster server from a stand alone box? Is it easy to just restore the msdb on the new server?

Thanks.

View 6 Replies View Related

SQL Server Instances In A Cluster

Feb 25, 2003

I an involved in a project that will have five sql server instances on an NT cluster.
I cannot find anywhere on Technet info on what happens when a single instance fails. Do they all have to fail over or just the failed instance. This is important so that we get the disk layout correct.

Can anybody help ? or point me to any docs on this.

View 1 Replies View Related

Multiple Instances Of Sql On A Cluster

May 7, 2008

I have a need to add a second Sql instance to an existing cluster. However I read in this article http://www.sql-server-performance.com/articles/clustering/clustering_best_practices_p1.aspx

that this is not recommended. Does anyone know why this is or what problems I may encounter?


Its is running Sql 2005 on a 64 bit windows Server 2003.

View 2 Replies View Related

Multiple Sql Instances In A Cluster

May 7, 2008

I have a need to add a second Sql instance to an existing cluster. However I read in this article http://www.sql-server-performance.com/articles/clustering/clustering_best_practices_p1.aspx

that this is not recommended. Does anyone know why this is or what problems I may encounter?


Its is running Sql 2005 on a 64 bit windows Server 2003.

View 18 Replies View Related

Multiple Instances Cluster Setup

Mar 21, 2002

Hi,

I have 2 W2K box's and want to install 4 SQL servers on each box & each different character set and want to setup clustering (Active - passive).

Do any one of you setup this type environment ?, Pl. let me know if you have any suggestions ..


Regards,

Madhu

View 1 Replies View Related

Sql 2000 And Sql 2005 Instances On Same Cluster

Jan 17, 2008

Hi

I have a cluster with 4 sql server 2000 instances and would like to upgrade 2 of these to sql server 2005 - is there any document or list of things to ensure I do

Thanks

View 3 Replies View Related

Moving SQL Server 2000 Instances To A Cluster

Dec 10, 2006

Hi,

We have a new failover cluster (Windows 2003 SP1, Microsoft SQL 2000 SP4) with each node of the cluster hosting 7 SQL Server instances in a 2-node active-active configuration connected to a SAN. We are planning to move some SQL Server Instances(from existing stand-alone servers) into this Cluster. Any insight into the process of moving SQL Servers into the cluster would be highly appreciated.

Best Regards,
Himansu

View 4 Replies View Related

SQL 2012 :: Cluster With Multiple Instances On The Same Node?

Jul 14, 2015

What I have- Sql server 2012 (Standard Ed) Cluster on Windows 2012 R2 with both instances running on the same node- just to save on License, i.e. technically it’s Act/Pas cluster.

What I am looking for- how to configure cluster (e.g. via quorum, etc) to force both instances failed together? Means if for some reason 1-st instance will fail to node 2 another instance should follow (otherwise it will be Act/Act cluster and 2-nd license is required).

If there is no standard way (cluster configuration I mean) to do it I should create some custom process to monitor where each instance is running.

View 3 Replies View Related

Recovery :: Multiple Instances For AlwaysOn For A Cluster

Jun 19, 2015

My environment has a 4 node cluster , 2 in primary and 2 in sec dc. Storage is sperate for both.

Need to setup always on for 4 Instances there on the 2 nodes of the primary dc. Is there any restriction in setting up always on for multiple instances for a cluster.

View 3 Replies View Related

Recovery :: Multiple Instances Of Server On A Cluster

Aug 18, 2015

Is it possible to have more than one instance of SQL Server on a failover Active/Passive cluster? What are the concerns/ramifications if that indeed is possible?

View 4 Replies View Related

Migrating SQL Data From MSA1000 Disk Arrays To SAN In SQL 2000 Cluster.

Apr 21, 2008



Hello All,

I have a 2-node cluster environment & I am planning to replace it with new hardware. Currently I am using MSA1000 Disk arrays. Now I would like to move my storage to SAN.

What are the necessary pre-requisite and actions to do this. Any particular thing, I must take care in planning.

Any help would be appreciated.

Thanks
Dev

View 1 Replies View Related

SQL 2012 :: Availability Groups And Failover Cluster Instances

Mar 21, 2014

I'm reading up on Always on and I am confused what is the difference between AlwaysOn Availability Groups and AlwaysOn Failover Cluster Instances.

View 3 Replies View Related

SQL 2012 :: Node Cluster Active / Passive With 10 Instances

Jun 5, 2015

It is an active passive cluster which doesn’t allow any testing. All instances have to be failed over together, we aren’t allowed to just failover 1 even for testing purposes. Node 1 is the active node and we can failover to node 2 for 30 days free of charge but services have to then be failed back.

We need to run the cluster with node 1 as the primary node always and 2 just use for failover testing or for less than 30 day periods whilst performing cluster patch upgrades etc.

Now l am sure we could fail over 1 instances at a time for testing and diagnosing issues plus if add a new instance that's not production to get to the platform level as the rest of the instances this would avoid taking production down in the fail over process.

View 5 Replies View Related

Installation Of Multiple Named Instances In Cluster Environment

Sep 11, 2006

Hi All..

We are planning to build a cluster environment on MS SQL 2005. We want to install multiple named instances in a single database server and use cluster for that database server.

Is this option possible ? Any relevant documentation would be helpful

Thanks in advance

Regards

Madhav



View 2 Replies View Related

Recovery :: OS Memory Reservation For Two Node Cluster Having Three Instances

Nov 9, 2015

We are running with a 2 node windows cluster having three SQL instances on it. 

OS: Windows server 2008R2 SP1
SQL : SQL server 2008R2 (10.50.6529)

Currently both nodes have 256 GB or memory and we are having multiple auto failover for resources. What will be the best practice for OS memory reservation (OS+tools) so that we can set SQL max memory settings accordingly?

View 5 Replies View Related

SQL Server 2008 :: Change IP Address Of Failover Cluster Instances

Mar 9, 2011

IF you need to change the IP Address of a SQL Server Failover Cluster instance, here is the steps:

1. Open up Failover Cluster manager.
2. Expand the MS Cluster Instance that your SQL Cluster instance resides on.
3. Expand Services and applications.
4. Select the SQL Server Service.
5. In the main window pane (Middle Screen), you should see your SQL Server Cluster name, expand the plus to the left of it.
6. Under your SQL Server Cluster name, you should now see an 'IP address' section, right click on it and go to properties.
7. In the properties pane, you can change your IP address by entering a static IP.....or assigning a DHCP enabled IP.

View 1 Replies View Related

SQL Server Admin 2014 :: Active Passive Cluster With 5 Instances

Nov 4, 2015

We have a SQL 2014 active passive cluster with 5 instances. When the cluster was installed one of the nodes was a virtual machine. As we started to have problems and this is not a Microsoft supported configuration we decided to replace the virtual node with a phyiscal one. On 3 of these 5 instances we configured static ports (1433 TCP) this was required for applications and firewall implementation.

Now with the physical node joined to the cluster we have issues with these three instances. Whenever one of these instances is moved to the passive node the server authentication is changed from mixed to windows only. I'm no SQL expert at all but to me it looks like the configuration of the instances are not replicated to the passive node? I found some similar problems on the net but these are mostly under sql 2008.

View 4 Replies View Related

New Instances Created After An SP2 Install

May 31, 2007

Do I need to reinstall SP2 everytime I add an SQL Instance?

View 1 Replies View Related

Install AS On Multiple SQL Server Instances?

May 12, 2002

Dear Listers,

1.) Is it possible to install Analysis Services on multiple SQL Server 2000 instances? If it is, then can you instruct me as to how to perform the install. If it is not possible, then does one restrict access to cube data via the Database Role Manager?

ie. The host box is - DOILAB30 with Analysis Services & SP2
Instance - DOILAB30/DOILAB30_FIN (Can AS be installed here?)

Do I severely restrict the membership of OLAP Admins?

2). Re. AS maintenance. - How do I backup and restore OLAP dbs/cubes etc. Following a restore, what issues, such as cube users/permissions should I be aware of? (if any).

TIA

John

View 1 Replies View Related

Can The SQL 2005 Install Upgrade From SQL 2000 Handle Multiple Instances?

Aug 7, 2006

Can the SQL 2005 install upgrade from SQL 2000 handle multiple instances?

View 1 Replies View Related

Setup And Upgrade :: Install New Instance On Server Where Existing Instances Are At Service Pack 3

Oct 7, 2015

If I install a new named instance of SQL Server 2008 R2 on a machine that already has 3 named instances that are upgraded to service pack 3, will the install of the new instance overwrite any of the current SP3 files?  Will I have to re-apply SP 3 to the existing instances?

View 4 Replies View Related

Install Cluster

Sep 19, 2007

I'm have been assigned the task of installing SQL Server 2005 as a cluster on a Windows cluster that has already been setup with a sans.

I've done alot of reading the past two days and I still have a few questions which I need answered before I begin.

Our setup-
DC - nothing but domain controller
S1 - SQL server 1
S2 - SQL server 2

S1 and S2 share the following drives (database) (transaction logs) (F) (G)

Do I install SQL on each of the clusters? If so, do I just follow the instructions the exact same? And am I suppose to power S2 down while I install SQL on S1 and then vice-versa?

Thanks.

View 6 Replies View Related

Help With CLuster Install

Jan 17, 2007

2 issues:



1. have 4 drives and all are within the SQL resource group but can see only 1 drive through management studio when doing a backup



2. Is restore only possible through the /backup folder on the default installation path as it is a small drive so can a restore be possible from any other locations



Any help

View 1 Replies View Related

SP4 && Hotfix On Cluster Install

Aug 11, 2006

I have two clustered server. (ms sql 2000 server, windows 2003 server) now i need to add one new server to the cluster and take the secondary node off.
I have installed SP4 & hotfix in my SQL Server cluster before.

My question is do I still need to install SP4 & hotfix in my new server?

Thanks in advance

View 1 Replies View Related

$#@$#%! SQL 2005 Cluster Install!

Feb 13, 2007

I have YET to have a 100% CLEAN install of SQL 2005 in a clustered environment. SQL 2005 Std. was not so bad, I think I finally managed a 99% clean install (no script errors on patches) on the third try.

SQL 2005 EE keeps erroring off on 2153 patch install. The error logs are no help at all; they simply stop logging activity at about the point that the error occurs.

For a premier product, this installation SUCKS.


Whooo. Okay. I feel better.

Here's my situation:
4-node Cluster (Windows 2003 Enterprise Edition), SP1
SQL 2005 Enterprise Edition


Process:
Install OS
Patch OS to SP1
Cluster OS on SAN
Configure Cluster Groups (DBC01, DBC02, DBC03) with cluster disks
Configure MSDTC (network access, configure cluster resources)

Start SQL Installation
Install RTM Binaries on Node 1 for Default Instance
Install Workstation and non-cluster components on remaining nodes
Install RTM Binaries on Node 2 for Named Instance

Reboot all nodes

Install SP1 for all instances from node 1

Install SP1 for all local services/applications for all other nodes

While attempting to install the 2153 SQL patch/hotfix, the process will either:
Hang while waiting for the first passive node for the default instance; or
Crash immediately with no error messages in the logs.


This is no nearly detailed enough, I know. I'm missing error messages and more. It's snowing outside and I have to get home. I just think that the installation for this product in a clustered environment is very unstraightforward at best, and at worst is a real liability to an organization since it's practically impossible to get it clean the first time through.

Regards,

hmscott

View 2 Replies View Related







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