I need some help on how to correct getting Event ID 1123 and Event ID 1122 on one of two cluster nodes every hour or some times frequently. Two times a not main node was removed from active cluster membership(Event ID 1135). This is a two node cluster running Windows Server 2003 EE SP1 (NovaScale 30...more >>

I am having this same error. Were you able to fix this error? email me at lucyricardo@wi.rr.com if you have a fix for this. From http://www.developmentnow.com/g/99_2007_6_0_0_987001/Cluster-Installation-Failure.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com...more >>

Hello there, I'm currently building up a SQL 2005 Active/Standby cluster in a DMZ. I have three NIC's in each server. Each NIC is connected to a different network: 192.168.100.1 is the public NIC 10.0.0.1 is the NIC used for communication betwen the cluster nodes (heartbeat) 192.168....more >>

Here's an update, In the setup for the job that ran the package, under the Step properties, on the General tab we had SSIS Package Store as the Package Source and under Package, point to the package we wanted under the MSDB folder. When we executed the job, the job was failing with the message '...more >>

Sorry for the repost... thought it better to put in a message of its own... We have installed SSIS in a cluster. We have a test package setup, however when we go into the properties for the package, go into Steps and on the General tab, under Server: we enter the Server Name, the package fail...more >>

We have installed SSIS in a cluster. We have a test package setup, however when we go into the properties for the package, go into Steps and on the General tab, under Server: we enter the Server Name, the package fails, but when we enter the IP address the package runs... We need to have t...more >>

What you will need is one or more fibre channel adapters (called Host Bus Adapters or HBAs) in each host computer. These can connect directly to the SAN/Smart array or through a fibre channel switch. The configuration is different for each. Fibre channel is really just a wrapper protocol aro...more >>

Lets see. x64 is definitely the best bang for the buck in the range you are looking at. More memory will help. Put in as much as the box can hold. Obligatory naming rant: Active/Passive really doesn't describe how things work. You are building a two-node, single-instance cluster. That...more >>

The answer is that SQL services share some common components. Plus, the installer has some generic setup logic. Finally, are you using the same service account for both services? If so, then permissions can get hosed during a broken update. -- Geoff N. Hiten Senior SQL Infrastructure ...more >>

> ...unless you create a snapshot on mirror database... > But in this way you have a secondary db alligned to snapshot time and you > could use it only for reporting and other activity that don't require you > real time data... > It's not properly load balancing but it's a way to reduce some a...more >>

Talking about nomenclature, unless your I/O traffic goes through some kind of FC switch(es) or at least a hub, I wouldn't consider the storage setup as a SAN. It's more like direct-attached. From what you just described, I'm not sure you want the cost of setting up a full-fledged SAN, which...more >>

> I'm not up to date with NLB. But if it's still just for load balancing, I > doubt you should configure it with databbase mirroring since database > mirroring is not meant for load balancing. Note that the standby is not > available, so there is nothing to load balance with. ....unless you cr...more >>

Hi, Thanks for reply, certainly helpful :) I note the need for clarity in nomenclature, correction welcome. If your (or anyone else), were to put names (not brands) to the bits, what nomenclature should I be using to described the various components and bits connecting them together? ...more >>

Hi, We are looking into implementing an Active:Passive SQL 2005 Cluster for a reasonably large and important system (< 1Tb) I'm not looking for advice re: particular brand etc., but on advice on type / type of connection to SAN that may be appropriate. The SQL 2005 instance(s) will be x6...more >>

Hi, We have a default clusterd SQL server 2005 with sp2 installed in one cluster group and then I have installed a default SSAS clustered instance in another cluster group and it works fine (can failover and user can connect). However, when I applying the sp2 to SSAS instance (with SSAS chec...more >>

"Mark" <Mark@discussions.microsoft.com> wrote in message news:A25E1719-BE43-4DBC-847D-B7E2F7EABE4D@microsoft.com... > Don't servers in the same cluster point to the same data on the SAN? > We have created additional RAID arrays (more disks) to improve performance > in addition to the beefed up ...more >>

Don't servers in the same cluster point to the same data on the SAN? We have created additional RAID arrays (more disks) to improve performance in addition to the beefed up servers. We plan on copying the old data to the new arrays for performance, and also we would like a week or so to test. ...more >>

thanks tom, it help a lot. Do you know how long it will take normally and if it is a risky process or smoth one? thanks again. ZP -- m "Tom Moreau" wrote: > You have to run the setup for each virtual server to tell the cluster to use > only the remaining nodes. The SQL Servers wi...more >>

We have 1 current Windows 2003/SQL 2000 Cluster (CL1). We are purchasing 2 more servers that are targeted to replace (CL1) for performance reasons. We have 2 goals. 1) Initially, bring up the 2 new servers as a new cluster (CL2) and migrate all data from (CL1) in order to properly test per...more >>

testing ...more >>

"Mark" <Mark@discussions.microsoft.com> wrote in message news:1A48882B-8730-4949-9C31-F84BA6E92B40@microsoft.com... > We have 1 current Windows 2003/SQL 2000 Cluster (CL1). > We are purchasing 2 more servers that are targeted to replace (CL1) for > performance reasons. > > We have 2 goals. >...more >>

The only risk I'd see is in a 2-node cluster and you evict one node. If you don't get the new node back into the cluster, then if the last remaining node fails, you're down. That's why I prefer to add a node before evicting an old one. -- Tom --------------------------------------...more >>

The words "Attach & Detach" really helped. Thanks for link too. Girish J Bhatia SharePoint Guru [MSFT] MCSE2003, MCDBA, SharePoint Certified, CCNA, CCNP, CCSA "Geoff N. Hiten" wrote: > How to move SQL Server databases to a new location by using Detach and > Attach functions in SQL Ser...more >>

You have to run the setup for each virtual server to tell the cluster to use only the remaining nodes. The SQL Servers will not be downgraded to RTM. Even though you are running "setup", it's not installing anything. It's just configuring. Setup can also be used if not evicting a node fr...more >>

How to move SQL Server databases to a new location by using Detach and Attach functions in SQL Server http://support.microsoft.com/kb/224071/en-us The fact that the target location is on a SAN does not matter to the procedure. -- Geoff N. Hiten Senior SQL Infrastructure Consultant Mic...more >>

I have a three node cluster with three virtual sql server 2005 installed. Now I want to take one node out of cluster to make a two node cluster. According to the post of Daniel ("evicting a node") and other reading, we have to run the setup again. My question are: 1. do I have to run the setu...more >>

Any Document which points out on how to move the databases to SAN? Girish J Bhatia "Girish J Bhatia" wrote: > Hi Experts, > > I have a customer running SQL Server 2005 and his database's are on the > physical server. We would like his entire database only on the SAN and not on > th...more >>

Whell Geoff If i run huge trasaction which takes 50 minutes and after 45 minutes node1 goes down. Will node2 first will rollback the transaction and only then the server will be available? "Geoff N. Hiten" <SQLCraftsman@gmail.com> ??? ??????:OjkeXTyGIHA.1184@TK2MSFTNGP04.phx.gbl... > No...more >>

Best practices for physical disk usage do not change because a SAN is involved. You can attach a SAN to a SQL serve and store data files on the SAN. Follow the usual practices when moving SQL data files and you should have no problems. Mirroring is supported on appropriate SAN hardware. ...more >>

Hi Experts, I have a customer running SQL Server 2005 and his database's are on the physical server. We would like his entire database only on the SAN and not on the server. Can anyone tell me what are the best practices to place this on a SAN. Shall we do a Mirroring on SAN and can we o...more >>