Creating a database on two nodes in a SQL Cluster

Tags:
Clusters
SQL Database
I have set up a SQL Cluster for three nodes, but I need to create a database on only two nodes. How would I do this?
ASKED: July 18, 2008  6:54 PM
UPDATED: July 18, 2008  7:07 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

In order to be able to isolate a SQL database to two of the three nodes in the cluster, where the other databases can be run on all three instances will require setting up a second instance of SQL Server on the cluster, and restricting that instance to only run on two of the nodes.

You can assign the Resource Group which you put the new SQL Server instance into to only the two nodes you wish to have as an option.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following