Monday, March 26, 2012

GeoCluster/SQL server sp3/windows 2003

Does any one have any experience with MS Clusters and
GeoCluster from NSI?
Also, does any one have any experience of installing sp3
for SQL Server on a Virtual SQL 2000 on a Windows 2003
Cluster?
I have good experience with GeoCluster from NSI. Basically, it simply
replicates the storage under MSCS. So, think of it as "Fire and Forget".
Once it is installed, each node in teh cluster has its own storage - but it
appears "shared".
From there install SQL (or Exchange or anything else) onto the cluster. GC
just allows you to split the nodes over some distance... After that, its
just clustering.
jason
"suzana_C" <anonymous@.discussions.microsoft.com> wrote in message
news:ded301c43c15$fd465040$a401280a@.phx.gbl...
> Does any one have any experience with MS Clusters and
> GeoCluster from NSI?
> Also, does any one have any experience of installing sp3
> for SQL Server on a Virtual SQL 2000 on a Windows 2003
> Cluster?
>
|||thank you for reply, I've been really frustrated trying to find any help on these issues...
So my problem is that I can't install sp3 on a virtual SQL 2000 server, installed on a Windwos 2003 cluster.
I have preinstalled MSDTC as a clustered app (according to Q301600) so I guess the install of SQL just skips it, because it detects it as being already there. SQL 2000 installs fine on a 2-node cluster win 2003. But when I try to apply sp3 for SQL 2000 it
fails with "Setup faile to perform required operations on cluster nodes" and in the sqlsp0.log I see something like:
Error running script: repltran.sql (1)
-or-
12:29:16 Setup is installing the Microsoft Full-Text Search Engine ...
12:29:16 "C:\sql2ksp3\x86\FullText\MSSearch\Search\SearchSt p.exe" /s /a:SQLServer$INST1
the above being the last line in the log
Is it a propper sequence of installing SQL 2000 sp3 on a Windows 2003 cluster.
I just want to mention I have read and tryied all of the following KB docs: Q815431, 309398, 318672, 321063, 815430, 301600, 811168.
Thanks for your help!
|||That doesnt sound like a GeoCluster problem.
The only thing that GC does it split the shared storage underneath the
cluster
- in a regular cluster, you define a shared-disk resource (call it drive
X and then when you install, SQL will select from the available clustered
drives (which here will be X)
- in a cluster with GC, you define a replicated-disk resource (call it
drive X and then when you install, SQL will select from the available
clustered drives (which here will be X)
Past that, everything is how you install SQL. Literally, no other
differences.
jason
"suzana ciur" <anonymous@.discussions.microsoft.com> wrote in message
news:A2D429AC-5C33-41EF-9C10-CE28518235A4@.microsoft.com...
> thank you for reply, I've been really frustrated trying to find any help
on these issues...
> So my problem is that I can't install sp3 on a virtual SQL 2000 server,
installed on a Windwos 2003 cluster.
> I have preinstalled MSDTC as a clustered app (according to Q301600) so I
guess the install of SQL just skips it, because it detects it as being
already there. SQL 2000 installs fine on a 2-node cluster win 2003. But when
I try to apply sp3 for SQL 2000 it fails with "Setup faile to perform
required operations on cluster nodes" and in the sqlsp0.log I see something
like:
> Error running script: repltran.sql (1)
> -or-
> 12:29:16 Setup is installing the Microsoft Full-Text Search Engine ...
> 12:29:16 "C:\sql2ksp3\x86\FullText\MSSearch\Search\SearchSt p.exe" /s
/a:SQLServer$INST1
> the above being the last line in the log
> Is it a propper sequence of installing SQL 2000 sp3 on a Windows 2003
cluster.
> I just want to mention I have read and tryied all of the following KB
docs: Q815431, 309398, 318672, 321063, 815430, 301600, 811168.
> Thanks for your help!

No comments:

Post a Comment