Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Migrating an existing installation to a SQL cluster

  Asked By: Jill    Date: Feb 14    Category: Sharepoint    Views: 1335

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?



1 Answer Found

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

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.