SQL Server 2005 Install

Question

SQL Server 2005 Install

gupta1282

Default port

Points: 1465
More actions
July 8, 2010 at 9:09 am

#139633

Hi All
Can we install non clustered SQL Server 2005 on already installed clustered SQL Server 2005 Server ? .
Let me give details
we have 2 node active passive sql server 2005 installation on windows server 2008 Enterprise.
Now we are going to apply services packs on our sharepint Appilication that will change DB schemas
So From recovry plan point of view , we will already install non cluster sql server 2005 on our active node & restore database.
Regards
Ghanshyam

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Tara Kizer SSCommitted Points: 1789 More actions · Answer 1

Your question is not clear.

Yes you can install the database engine as a non-clustered component. But it means it can't failover to the other node. I don't understand why you'd want to do this.

Could you describe your situation in more detail?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
Ramblings of a DBA (My SQL Server Blog)[/url]
Subscribe to my blog

gupta1282 Default port Points: 1465 More actions · Answer 2

Hi

Let me explain the situaton.

We have 2 Node Active Passive Cluster installed , Now our Appilication developer are going to apply SP 2 on Sharepoint application that will change the DB Schemas & They will take 4 -5 days to check changes. Business can not tolerate this much of time.

So our Strategy is to install another non cluster instance and restore all DB to that so that appilication can continue till changes to be checked.

One more doubt is that , can we take resoureces (Clustered Disk used in clustered instance of sql server ) to install non cluster instance of sql server & DB or should use seperate resources for this .

Regards

Ghanshyam

Leonard Rutkowski SSCrazy Points: 2668 More actions · Answer 3

I actually have a similar situation, but for a different reason. We have a 2 node active\passive, SQL Server 2008. I would like to install a non clustered, 2008 instance, for testing purposes. So, is it possible? I don't care if the test instance fails over.

Actually, I would like to put it on the Passive side, and if we get a fail over, I would shut the test instance down. Although that may require another SQL Server license, but I'm not sure about that. If it is on the active side, I can put as many instances as I want.

My internet research shows mixed answers, and I can't find anything definitive.

Thanks,

Leonard

S. Kusen SSChampion Points: 10936 More actions · Answer 4

You would not be able to pull the disks from the clustered SQL instance (and you probably shouldn't want to since the upgraded application will be running there). You'd be relegated to using the local disk on the server in order to do you second install.

The question of licensing is different based on your agreement and what was purchased. At my company, our agreement is that non-production instances do not require a license, so in the case mentioned, the clustered instance will essentially become non-production during the upgraded "test" time period.

The ideal situation would be to get a staging environment, pull the production databases down into the staging DB server, and point the application hosts to that server to verify that everything functions as expected. It sounds like the SP2 for SharePoint is going on the production boxes without proper validation to me.

SK