What is the best method for moving databases from one server onto a clustered setup? Obviously you can use backup/restore or detach/reattach. What I really need to know is what steps you have to do after this. There must be security problems with the new database. ie how do you ensure secu...more >>

SQL 2000 (no service pack installed yet) on Win2000 My newly configured failover cluster is experiencing sudden stops of the SQL Server service and subsequent restarts of the service. The last error log terminates with the following message: SQL Server terminating due to 'stop' request from Ser...more >>

We have a four node cluster which was in a NT 4.0 domain - only two of them active. Our goal is to make 3 active 1 passive. Recently we migrated to Active Directory on Win 2003. The CLuster nodes are running win 2003 as well. In the NT 4 domain I was able to run the setup and create named instan...more >>

In a clustered SQL Server 2000, can i deny access to BUILTIN\Administrators? Can i have problems in doing so? Thanks. ...more >>

In the step by step instructions - see below [In the Destination Folder area of the Setup Type dialog box, verify that the Program Files location is set to a valid local drive on each node (for example, C:\Program Files\Microsoft SQL Server) and that the Data Files location is set to the dr...more >>

My Current configuration is: Windows 2003, cluster service, SQL 2000 sp3 I have 3 databases I want to run one in the cluster node1 and the other two databases in the node2. So, when node1 fail, node2 take the node1 DB and vice-versa. Is possible? do you know some URL where I can find infor...more >>

When installing SQL Server onto a two node cluster setup - how many shared disk drives do you need ie am I right in thinking that you should have the following shared drives C:\ for SQL Server installation D:\ for data files E:\ for log files Q:\ for quorum disk Also I am right in thinkin...more >>

I am not using a SAN to setup Win2003 CLusters, two nodes. How can I share the hard disk in order to make this work for both nodes ? All documentation I read states that I must have shared hard disk common to the two servers and that's not clear to me when all I have is that hard drive on the ...more >>

Hi All Client has decided they want to rename the Virtual SQL Server from (lets say) SQLA to SQLB. Fair enough. Uninstall SQL Server and reinstall. Am I right in thinking that I cannot restore the master from the SQLA incarnation to the SQLB incarnation. Clearly I would like to do this ...more >>

I posted this in the Windows Server 2003 General Discussions then realized it belongs here... Can someone tell me if there are any issues with installing Windows 2003 Server SQL clusters on two different server hardware configurations? Example: Cluster 1 running on a Dell 2650 and Cluste...more >>

OK - Hi all I have an irritating problem with a cluster and perhaps some of you can short circuit it for me... Environment Windows Server 2003 Sql Server 2000 EE - SPK 3 3 node stretch cluster - only 3rd node is stretched Problem Summary... Node 1 (lets say 10.0.0.1) is ocas...more >>

I would like to add a VB Script to the SQL Cluster so that in the event of a failover the script will execute on the new active node. The script goes out and checks for the existance of some key files once a day. I am running Windows 2003 SQL 2000 in an Active / Passive configuration. ...more >>

I am thining about either setting up Cluseting on SQL Server or follow log shipping. Does anyone has any recommendation as to which one should be chosen?? Also, can someone direct me to a proper location where there is step by step instruction on how to set up Clustering/ Log Shipping. ...more >>

Join members of the Microsoft development team as they chat about what's new in SQL Server 2005 Beta 2. One major new feature that's been announced in Beta 2 is data encryption. Come chat about other new features and changes that exist in this highly anticipated beta of the next version of SQL...more >>

Hi all, I have an MS SQL active/passive cluster with 2 nodes of windows 2000 advance server. One of the node has hardware failure. After I restored win 2k server from ntbackup, i can't re-join the cluster. Though I can see both server are up in the cluster administrator, but it fails when f...more >>

can sql server 2000 database load balancing be achived by using sql clustering? Say an active/active/passive type set up? Thank you....more >>

we are using sql server 2000 clustering .Pl help me , tell me about how to moniture cluster and what are diffrent counters (performance and other ) ...more >>

Is their any document avaiable on monitoring SQL cluster . If yes can some one please send the link ...more >>

Hi, In a 2-node SQL Server High Availability architecture using Failover Clustering coupled with Log Shipping in an Active/Passive configuration, how many SQL Server Enterprise licenses to I need - 1 or 2? Only one node is really receiving SQL requests, but with log shipping I didnt k...more >>

Hi, We are trying to implement SQL server failover by using Windows 2003 "Enterprise" clustering and SQL Server "Standard" to try to save the cost of SQL Server Etnerprise. From what I understand we cannot have automatic failover of the SQL server service with this configuration. Cou...more >>

Hi there, I have a fail-over cluster that consists of two nodes. Active/Passive (one owner preferred). Two nods connected to external disk array. Everything has been working fine in this environment except of one thing: The Virtual SQL server is available by the NetBIOS name, but is no...more >>

Is there any documentation how to handle this. Any suggestions are welcome Tnx, Erik ...more >>

Hi, I have a question regarding how to find out which physical node the virtual server is using. Currently my SQL Server 2000 setup is as follows: Physical Nodes: --------------- ClusterA ClusterB Virtual Server: --------------- SQLCLUST I know if I use Cluster Administrator or ...more >>

Guys, can you help? I have no SQL perfromance counters on my SQL cluster. I manually rebuilt the performance counters last night, using article 300956 & 267831, but to no avail. Does anyone know of a fix for this problem? Cheers, Pedro...more >>

Hello, We're are in the basic design process for a cluster. We have some confusion as to whether SQL Server clustering supports a share nothing scenario - that is where the clustered machines have their own storage and do not share storage. We're trying to find out if this is supported,...more >>

Hi, We have a clustered SQL server 2000. I would like to know If it is possible to create SQL login for a local NT useraccount using windows authentication on that clustered server. And later I would like to use that login as a user for one of the databases. I could successfully add a domain ...more >>

Reposting under MSDN registered nospam alias. I have installed SQL Server on W2k3. The cluster works fine (this is for a SharePoint 2003 deployment). However I am unable to connect to either machine or the cluster DB from my workstation using Enterprise Manager or Remote Desktop. Here are th...more >>

We are using SQL2000 and considering clustering the solution. Could someone point us good documentation on clustering. We are particularly interested in Active/Active/Active/Passive Thanks in advance Amar...more >>

Hi I'm trying to setup log shipping between two 2-node Active/Passive clusters and I keep getting an error "Unable to copy the initialization file to the secondary server". I've search KB, to find an article KB/811890, but both clusters are in the same domain, and thus this article shouldn't a...more >>

Posting to groups again.. Can someone give me a list of outside vendors that help support High Availability of SQL across geographically dispersed locations. I know Veritas, NSI, EMC have some solutions that eliminate the shared disk storage limitation of clustering.. Thanks.Using SQL 2000 ...more >>

In an article in another usenet group, a few months ago, it was mentioned that MS were developing an updated document for the steps to cluster the 64-bit version of Analysis Services. I'm the tech lead in one of my countries first implementations of 64-bit SQL, and this has been an issue for...more >>

I had set up HP packaged cluster (DL380 x 2 WIN2K3 + MSA500 with high availability kit) . On the storade device I have 2 arrays mounted as volumes. First is 2 36G drives in RAID 0+1 . Second 3 36G drives RAID 5. The default cluster configuration uses the first array as quorum resource for SQL g...more >>

I am looking for information/procedures for changing the domain for an existing W2K/SQL2K cluster. The cluster currently is a part of an NT4.0 domain and will be migrating to a W2K AD domain. This seems like it should be a simple change but I can't seem to find any info or anyone who has done ...more >>

Hi. If I run two SQLServers at two different locations, allowing only network traffic between them (ie. no shared storage/SAN), what options do I have for providing fail-over? Would I need to run an OS level cluster? Any pointers greatly appreciated, Morten...more >>

Application launched by a batch files (on cluster win 2000 advanced server) run more slowly then the same application lounched by the same batch files on PC stand alone. The servers have on board four CPU pentium 3.04 GHz, the stand alone PC have one single pentium 4 3.04 GHz. The application ...more >>

i have a Dedicated SQL server running 2000Adv. and a server running 2003SBS (premium)as my DC running a 75 pc network.wanted to do a nightly SQL DB back-up to the SBS and was wondering how i should go about it. I was thinking i could make it a replication server and just replicate nightly ...more >>

I ma trying to run Sp3a on a virtual server after SQL Server install on it. However, it keeps saying that the vitual server does not exist on the local machine. How do I get around this????Help...more >>

We just went through a kind fo painful upgrade from a Windows 2000/SQL 2000 SP3 2 node cluster to a Windows2003/SQL 2003 SP3 2 node(new servers) cluster upgrade. Everything I had read pointed to this being very simple, stating evit one node, add the new server, install SQL, install SP3, failover ...more >>

Is anyone aware of any issues that can arise from installing MS SQL Server 2000 on the root of a drive - x:\\MSSQL\Data - instead of using the using the default structure - x:\Program Files\Microsoft SQL Server\MSSQL\Data?? I have always installed to the root directory be it stand-alone or clus...more >>

I have two w2k3 Servers on a SAN. I also have separate instances of SQL Server on the separate physical servers. I have have set up a cluster between the two. And I also have them in separate groups. I am trying to set up an active/active on SQL Server. However, when I try to set up the 2nd virtual ...more >>

I have a server that Windows 2000 Advanced Server that is clustered (Active/Active) with SQL Server 2000 with SP3A. There are periods when the server CPU usage can be at 100% for 30 minutes or longer. What some of the resources that should fail when the CPU usage is at this rate for an...more >>

In log shipping between 2 computer I'm aware that you have to use Enterprise edition on the primary server. Can you use Standard edition on the secondary server? I've read a bunch of MS answers and they seem to leave that question open. Thanks....more >>

I'm currently running 2 SQl Instance as an active/active cluster. Both servers are identical running windows 2000 Advance server. SQL Server Enterprise 2000 with settings exactly the same on both servers, 8GB of memory, both servers are new builds, Windows sees all the memory, boot.ini a...more >>

I got a question/prob: I changed the ip addy of my CLUSTER (physical) and now my virtual servers won't pass the "online pending" stage. They maintained the old ips.Is this possible? Can anyone tell me what can i do to get the online pending to online? any info? ...more >>

Ref KB298568 the Note after last step (step 7) states that you should restore recent backup of master. Isn't this defeating the object of rebuilding it! Any neat tips/tricks for recovering objects from previous master? regards, Tim G-J...more >>

Hi, i tried to install a SQL Server 2000 Cluster on a Windows Server 2003 but the Setup Window not even poped up after clicking "setup.bat". I'm seeing 3 Tasks of the setup in the Taskmanager but i dont get any window. The System is a Dell Poweredge and the cluster is running without any proble...more >>

Hi, We had to replace one of our SQL cluster nodes. the first node is SQL2K = SP3a. When we try to install the second node with SQL2K we get and error when it = tries to start the file copy after all the settings are requested: "Setup was unable to create the silent installation files. Pa...more >>

Hi all! how many failover nodes are supported by SQL SRV 2k on a windows server 2k3 EE cluster? I have only found information about 4 failover nodes on 64 edition of sql. Tks in adv. Regs. ...more >>

We have about 40 DB's blackening 40 web sites running on a single SQL2k/Win2003 an A/P cluster. When I roll the cluster from one node to the next I'm wondering exactly what sort of outage our clients would see. Since the entire cluster rolls in under a minute would there just be a delay on the...more >>

Hi guys, In my lodg shipping setup i selected the option terminate users in database. but if the database is open the restore is failing with following error. [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3101: [Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive access could not b...more >>