Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

How to move SQL Server 2005 instance from non-clustered to..

 
   Database Forums (Home) -> Clustering RSS
Next:  Finding top x percent of data  
Author Message
Bogdan S.

External


Since: Dec 05, 2007
Posts: 1



(Msg. 1) Posted: Wed Dec 05, 2007 12:30 pm
Post subject: How to move SQL Server 2005 instance from non-clustered to cluster
Archived from groups: microsoft>public>sqlserver>clustering (more info?)

I have two node cluster (active-pasive) and two instances of SQL server 2005
running on that cluster. Default SQL instance was installed as clustered, the
second named instance was not installed as clustered. I want to move named
instance form non-clustered to clustered. What is the recommended way for
moving non-clustered instance to clustered?

Thanks,
Bogdan

 >> Stay informed about: How to move SQL Server 2005 instance from non-clustered to.. 
Back to top
Login to vote
Geoff N. Hiten

External


Since: Feb 23, 2005
Posts: 443



(Msg. 2) Posted: Wed Dec 05, 2007 4:18 pm
Post subject: Re: How to move SQL Server 2005 instance from non-clustered to cluster [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Create a new clustered instance and do a data-in-place migration.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Bogdan S." wrote in message

>I have two node cluster (active-pasive) and two instances of SQL server
>2005
> running on that cluster. Default SQL instance was installed as clustered,
> the
> second named instance was not installed as clustered. I want to move named
> instance form non-clustered to clustered. What is the recommended way for
> moving non-clustered instance to clustered?
>
> Thanks,
> Bogdan

 >> Stay informed about: How to move SQL Server 2005 instance from non-clustered to.. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Clustered SQL server 2005 - Maintenance plan problem - Hi Everyone, Short Problem. Here is my config: - SQL Cluster Active/Passive - MSSQL 2005 SP2 - On the nodes: SQL engine, Worstation components - Windows 2003 SE SP2 Here is my problem: - When logged on the primary node (active one) I can browse..

getting a clustered instance to recognize a new drive - I've added another cluster resource drive to the group and sql 2000 instance is in. Sadly, the instance is not recognizing the drive, which is making it pretty hard to create backup devices on the new drive. which is why i added the new drive. Is there..

A little help with clustered SQL server setup. - Guys, I keep getting errors while trying to install SQL 2K5 server on Win2K3 x64 R2 SP2 cluster. The setup sequence was 1. Install SQL client/tools on all nodes 2. Install first instance of SQL server 3. Install SQL SP2 for client/tools on all nodes 4.....

Installing performance counters on clustered SQL Server - We have 2 clusters, both 2 node active/passive, both have SQL Server running on the Active node. I am using Idera's SQL Diagnostic Manager to monitor and gather statistics on the SQL instances. However, on one cluster, not all of the performance..

ODBC Data Source On Clustered SQL Server - We created an ODBC datasource on a SQL Server in the cluster. Then there was a hardware failover and subsequently unrelated DTS processes failed because the data source wasn't defined on the failover machine. Even though those processes did not use th...
   Database Forums (Home) -> Clustering All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]