January 16, 2003 at 6:50 am
In a 2 node cluster environment, I know I need to install SQL virtual server on each node. My question is how many copy of each database do I need to create, where do I create the databases? On a share disk or on each node? Any white paper on installing and creating databases in cluster environment and backup issues?
January 16, 2003 at 1:18 pm
You don't need to install SQL virtual server on each node! You install it on the shared disk. We have an active/passive cluster with a shared array. We loaded SQL Server onto the shared array. Part of the installation will require you to fail the cluster over as it copies certain files onto each node (registry type stuff and other files).
NOTE: You must have two licenses for SQL Server.
So, one installation on the shared disk is all you need. And that's where you will put/create/build your databases.
-Bill
January 16, 2003 at 1:20 pm
Thank you SQLBill.
January 16, 2003 at 2:35 pm
Just a clarification. You need a license per active instance. So if you are running an Active/Passive cluster, you only need one license. If you are running Active/Active, you need two.
SQL Server 2000 is cluster aware. There are Microsoft KB articles on how to do this, but also take a look at Brian Knight's articles. He has a step-by-step, among others.
http://www.sqlservercentral.com/columnists/bknight/
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
January 17, 2003 at 6:08 am
Bkelly is correct....I was working with Veritas' Backup Exec when I responded to your posting. Backup Exec requires two licenses for a 2-node cluster. SQL Server only requires one license.
I apologize for the error and thanks to BKelly for correcting me.
-Bill
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply