all groups > sql server clustering > august 2006 > threads for august 29 - 31, 2006
Filter by week: 1 2 3 4 5
SQL Server 2005 Cluster Install
Posted by Loren Z at 8/31/2006 1:02:14 PM
I am doing an SQL Server 2005 Cluster install. The install appeared to go
okay. On the active node everything installed fine. However, when we looked
at the other node only the configuration tools got installed. SQL Server
Management Studio did not get installed. Would anyone know what caused ... more >>
SQL Server 2000 cluster resource fails to start
Posted by Shri.DBA at 8/31/2006 7:24:02 AM
Hi All,
I am have installed a single-node sql server 200 cluster on windows 2003
(SP1).
The SQL Server resource is not starting if MSDTC is configured as a cluster
resource.
The SQL Server resource is starting if MSDTC is not configured as cluster
resource.
Regards
Balaji... more >>
Primary and Secondary Node
Posted by Bala Prasad Peddigari at 8/31/2006 12:24:01 AM
How do we figure out Primary and Secondary Node for a active-passive
clustering setup on SQL server 2000. Are there any simple and straight
commands to find them?... more >>
SQL 2005 64 Bit OR 32 Bit
Posted by bijupg NO[at]SPAM hotmail.com at 8/30/2006 9:31:07 PM
Hi Guys,
I am planning to upgrade my sql 2000 32 bit to sql 2005 on new cluster
hardware.
shall i go for 32 bit or 64 bit ?
my application is a critical OLTP application with DB size around 10 gb and
i hve application written using visual studio.net,VB 6.0 ,ASP and other sql
servers 2000 3... more >>
N+1 Configuration
Posted by DTully at 8/30/2006 3:49:02 PM
Well - first TIA!
We have an Active/Passive cluster running W2K3 Enterprise X64 Sp1, 32GB RAM
and SQL Server 2005. We're moving to a N+1 configuration (and then maybe N+M
later), but I'm running into an error.
After I cluster the third server and try adding the failover node (it's the
sa... more >>
Instance of prod and satge on same cluster?
Posted by _Stephen at 8/30/2006 2:11:34 PM
What are cons for placing both stage and production versions of the same db
on our only "real" cluster? 4 cpu / 4 gig ram dell server.
We have heavy batch work where we prepare data for submission to another
process, so there is a ton of munge work in the batches for 2+ hr durations
and th... more >>
Multiple instances and RAM ?
Posted by _Stephen at 8/30/2006 1:53:52 PM
I have a cluster A/P 4 processor 4 gig of ram with 3 gig allocated to SQL
server. I have put on the same cluster my testing of 2005 and will switch
over soon.
How does SQL Server deal with RAM between the 2 instances?
TIA
__Stephen
... more >>
SAN maintenance - still need cluster
Posted by Bert69 at 8/29/2006 9:41:02 AM
Hi,
We have a 2 node active \passive windows 2003 cluster hosting SQL and a
virtuals SQL server isntance.
We need to perform maintenance on the SAN (24 hours outage), but need to
still keep SQL accessible. Is there anyway to move data from SAN disk to
local drive of one node and not los... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL Server 2000 AWE on Windows 2003 64bit
Posted by Chris at 8/29/2006 6:48:00 AM
I currently am running a Windows 2003 64 bit server with SQL Server
2000 service pack 4 with the following hotfix
http://support.microsoft.com/default.aspx?kbid=899761. I am trying to
enable the AWE support to take advantage of my 8 gigs of memory. I
have currently ran the sp_configure 'awe en... more >>
Adding Databases to an existing SQL Cluster
Posted by Brian at 8/29/2006 6:31:01 AM
I need to move SQL 2000 databases from existing stand-alone servers to an
already established SQL 2000 Cluster. What is the best way to do this
without losing permissions, jobs, stored procedures, etc? The drive letters
in which SQL is installed will likely be different as their are multiple... more >>
|