Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

Migrating an existing installation to a SQL cluster

Asked By: Jill Wells Date: Feb 14, 2006 Category: Sharepoint Views: 303

I have a SharePoint installation that currently uses a single SQL
Server and connects to the default instance. I want to migrate to a
cluster without doing a full backup/move/restore. I'm thinking if I set
up the cluster with the same name as the current SQL server it should
be transparent to SharePoint. Has anyone tried this?

Tagged:migrating an existing installation to sql cluster

1 Answer Found

Answer #1 Answered By: Karla Morrison Answered On: Feb 14, 2006

We did that exact thing and it worked fine. Had a stand alone SQL server named “sq01” with a SAN backend. Replaced it with a cluster of two new machines. Gave the cluster the name “sq01” and pointed it at the same SAN drives. If I were to do it again, I would remove the full text search catalogs first, and rebuild them after the new SQL server is installed. That caused us some problems until we rebuilt it all.

Didn't find what you were looking for? Find more on Migrating an existing installation to a SQL cluster Or get search suggestion and latest updates.