Recovery :: Create Server Cluster On Existing Server
Aug 3, 2015
I have an urgent query that we are running SharePoint server 2013 on single server and installed SQL server 2012 on single server, our management decided that we need to configure failover cluster on existing SQL server. I want to confirm that it is possible that we can install failover clustering services on existing SQL server and then add an other server on SQL 2012 for high availability or do we need to first install failover cluster service and then install SQL server for failover clustering.
View 2 Replies
ADVERTISEMENT
Aug 17, 2015
We have a requirement to build SQL environment which will give us local high availability and disaster recovery to second site. We have two sites- Site A & Site B. We are planning to have two nodes at Site A and 2 nodes at Site B. All four nodes will be part of same Windows failover cluster. We will build two SQL Cluster, InstanceA will be clustered between the nodes at Site A Server and InstanceB will be clustered between the nodes at Site B, we will enable Always On Between the InstanceA and InstanceB and will be primary owner where data will be written on InstanceA and will be replicated to InstaceB. URL....Now we want we will have instanceC on the Site B and data will be writen from the application available on Site B, will be replicated to the instance on the Site A as replica.
View 6 Replies
View Related
Aug 24, 2015
I am learning SQL Server failover cluster installation. My question is regarding the options to install failover cluster instances on the Windows Failover Cluster. I have seen ead there are two options to do so.
From the installation center, installation option-> New SQL Server installation option and afterwards add node to SQL Server failover instance.From Installation Center, Advanced option-> Failover cluster preparation and then Failover cluster completion step.What is the difference between these two options and which option to use in which scenario?
View 5 Replies
View Related
Mar 6, 2004
I have a 2 part question about adding a new 'named' Virtual Server to an existing Clustered SQL Server 2000 install.
I have a 2 node MSCS Cluster (WIN2K advanced Server sp4) with a default SQL Server instance. This has been in production and working fine. I created a new Cluster resource and reran SQL Server 2000 ENT setup and added a second Virtual SQL Server (named instance). After many problems, finally got the second Server installed. Now I have 2 SQL Server instances in the Cluster - from what I understand, you can have up to 16, each seperate installs with seperate Cluster resources.
Thus the problem:
For the Second Instance, I have specific instructions from the Applications vendor on how to install SQL Server to work with their APP. I need install SQL Server WITHOUT the Full Text Search component and WITH a specific Server Collation (Binary order for use with the 850 Multilingual character set). (I have done this same setup on standalone SQL Server installations for this APP and they have gone smooth).
When I installed the new Virtual 'named' instance in my Cluster, I Could NOT 'DESELECT' Full Text Search when I choose Custom install.. it does not appear as an option???
Also, I chose the "Binary order for use with the 850 Multilingual character set" during the installation, but that is not the Server Collation that is installed...
I have already installed SP3 for SQL Server against the Virtual Server on this Cluster, as well as a HotFix... and Now I'm thinking I need to rerun the SQL Server installation, uninstall the second server and reinstall to see if I can fix the 'Collation problem' .. but I'm not sure if this is the right course of action.
Does anyone know why I cannot 'deselect' Full text search component at install, and any ideas why it did not install with the SQL Server Collation that I specified at install????
View 2 Replies
View Related
Aug 19, 2015
We are using SQL Server 2012 for both production and development server. Currently, i have plan to transfer the full backup of SQL server database to the development server and then restore it on the development server for testing purpose, so we don't want to disturb on the production.
I have successfully backup the database from the production server and transfer to the development server. however, i encounter some difficulties when trying to do restore. my question is:
1. do i need to firstly create an empty database on the development server and then restore it into this empty database? say i create database call "Test2", then i perform a restore into this database.
2. currently, there is already an existing database being restored previously in the development server and this database is actually the older version of the backup that being restored by the previous engineer. should i remove this database first and restore a new one or both of the database can coexist as long as we put different name for the database?
View 6 Replies
View Related
Feb 16, 2007
does anyone know of any potential issues of using a 32 bit sql server 2005 instance used for disaster recovery of a 64 bit sql 2005 cluster ?
thanks
View 2 Replies
View Related
Aug 18, 2015
Is it possible to have more than one instance of SQL Server on a failover Active/Passive cluster? What are the concerns/ramifications if that indeed is possible?
View 4 Replies
View Related
May 27, 2015
I have getting issues when i am creating listener for always On . Error shown as below
Can not bring the Windows server fail over cluster (WSFC) resources online. (Error Code 5942). The WSFC service may not be running or may not be accessible in its currents states, or the WSFC resources may not be in a state that could accept the request.
For information about this error code see "system error code" in windows development documentation
The attempt to create network name and IP address for the listener is failed. The WSFC service may not be running or may not be accessible in its currents states or the value provide for the network name and IP address may be incorrect. Check the state of the WSFC cluster and validate network name and IP address with network administrator. (Microsoft SQL Server error 41066) ...
View 2 Replies
View Related
Sep 4, 2015
We have a SQL 2008 Instance existing on active/passive cluster with 2 nodes running on Windows server 2008 R2 Ent. Edn.
Now we need to install another SQL instance on this cluster. So what are the prerequisites apart from new IP address? Do we need shared disks or can the existing disks can be utilized?
View 3 Replies
View Related
Feb 11, 2008
This is a fresh install of SQL Server 2005 (64bit) on a Windows 2003 R2 SP2 64bit OS. The Cluster has been built and SQL 2005 has been installed (Database Engine(clustered), Analysis Server(clustered), Notification Server, Integration Server, Reporting Services). SQL 2005 SP2 has been installed.
Now, I want to install Notification Server, Integration Server and Reporting Services on the second node for high availability.
When I select 'Install New Components' from Add/Remove Programs, the System Configuation Checker tells me theres a version difference and to:
To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter.
I'm using the same binaries as the original install. Could this be a result of installing SQL 2005 SP2?
Can someone help me out with this. I'd prefer using the setup interface instead of a command line script.
View 4 Replies
View Related
Aug 22, 2007
Hello ,
1.Is there a way to generate an .sdf (SQL CE DB) from an existing SQL Server 2005 DB?
So that the sdf file has the same tables and data as SQL server 2005 DB.
2.Is there a way to copy data in Excel file to an .sdf file (SQL CE DB)?
Thanks,
Rookie
View 6 Replies
View Related
Mar 4, 2015
Can we create the Partition on Existing Table?e.g Create table t ( col1 number(10,0), Col2 Varchar(10)) ;After the table Creation can we alter the table to partition the table.
View 2 Replies
View Related
Apr 10, 2014
I ran the Advanced cluster preparation for a new sql instance on an existing cluster.
Slq Server 2012.
After is completed, it was successful, I realized I specified the wrong Instance Root directory.
Is it possible to remove what the preparation installed? Or is it possible to change the root directory?
View 3 Replies
View Related
Nov 3, 2015
We have SQL cluster installed on top of windows cluster on VM environment. Node1 and Node2 under Windows Failover Cluster. SQL instance is currently on node2 the instance is up and running, but SQL Cluster service remains online pending and it restarts the instance on every 5 minutes.
SQL Browser service are running successfully.TCP/IP ports are enabled and configured.If we start the SQL server agent it is on for seconds and stopped immediately .Cluster Service is attempt to connect to the SQL service every few minutes (setting in SQL cluster resource) for the IsAlive check, if this fails then the SQL resource is restarted even if the instance was online. Hope this is what happening exactly.
[sqsrvres] ODBC Error: [08001] [Microsoft][SQL Server Native Client 11.0]SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. (268435455)
00001024.00053314::2015/10/30-19:57:50.772 ERR [RES] SQL Server <SQL Server (SIMAH_COMMDB)>: [sqsrvres] ODBC Error: [HYT00] [Microsoft][SQL Server Native Client 11.0]Login timeout expired (0)
00001024.00053314::2015/10/30-19:57:50.772 ERR [RES] SQL Server <SQL Server (SIMAH_COMMDB)>: [sqsrvres] ODBC Error: [08001] [Microsoft][SQL Server
Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books
Online. (268435455)
00001024.00053314::2015/10/30-19:57:50.772 INFO [RES] SQL Server <SQL Server (SIMAH_COMMDB)>: [sqsrvres] Could not connect to SQL Server (rc -1
View 5 Replies
View Related
Oct 8, 2015
can we join a node in a windows cluster which is already in a different cluster?
We have this requirement as we need to setup readable secondary ( always on AG) on the third node.
View 2 Replies
View Related
Jul 15, 2015
We are planning to change all IPs of PRODUCTION Failover Cluster Setup. In my cluster setup ... we have 2 Physical Nodes with windows-2008, Roles are MSDTC and SQL-2008R2.
IP change for:
1. Both Nodes(Physical)
2. MSDTC
3. SQL Server
4. windows Cluster
So Almost... All IPs are going to change.
Im DBA here, I need to take care of SQL cluster and MSDTC. But I haven't performed this activity before.So I'm worrying about Impacts and consequences of this change. steps how should I perform this activity.
View 9 Replies
View Related
May 8, 2007
Hi
We are planning to upgrade the SQL Server in our production environment from SQL Server 2000 to SQL Server 2005. This is a 4 Node cluster environment with 3 Databases on 3 Virtual instances. The main requirement is to achieve this with no/minimal downtime.
Could you please suggest or direct me to any documentation for the best practices used to upgrade such an environment?
Thanks
Priyanka
View 2 Replies
View Related
Dec 28, 2007
We're upgrading a SQL Server 2000 cluster (Active/Passive) running on Windows 2000 Server to a SQL Server 2005 Cluster running on Windows Server 2003. We can't purchase new hardware and we have no spare hardware. We also need to move from Windows 2000 Server to Windows 2003 Server at the same time. We want to keep downtime to a bare minimum.
What we were thinking was the following steps... Anyone try this?
1. Break the link between the servers.
2. Install a fresh copy of windows 2003 server on one side along with SQL Server 2005. While this step is running, the active node would still be live on Windows 2000 Server and SQL Server 2000 serving our customers.
3. Restore a copy of a backup from the active production side to the node we're upgrading and at that point we would bring the active node down, switching the active node to be the newly upgraded server.
4. As a final step, the old active node would now have the link to it broken, we would install a fresh copy of windows 2003 server on it and sql server 2005. At this point we would bring it back into the cluster and the cluster would be complete again.
Thoughts?
View 2 Replies
View Related
May 14, 2008
Friends -
Need your help and guidence for doing upgrading SQL Server 2000 Cluster to SQL Server 2005 Cluster.
Let me explain my current environment.
1. Currently SQL Server 2000 Cluster environment is running on Windows 2000 Server we need to upgrade this to SQL Server 2005 on Windows 2003 Server. >>> Production environment.
My Plans:
1. On Testing Environment Install SQL Server 2000 cluster on Windows 2003 Server and do a restore of databases from the produciton environment.
2. Upgrade In-Place from SQL Server 2000 Cluster to SQL Server 2005 Cluster.
My doubts
1. Can i install SQL Server 2000 Cluster on Windows 2003 Server. Is it possible or not.
Please advise me and correct my steps.
Cheers
VSH
View 1 Replies
View Related
Dec 23, 2014
is bulk logged recovery model support point in time recovery
View 9 Replies
View Related
Mar 5, 2001
Hi All
This is a Pearler !!. SQL 7 and NT 4
Site A and B are 30 miles apart
"Site A" SQL 7.0 Cluster with Drives on Shared Storage.
"Site B" SQL Server Cluster with Drives on Shared Storage
Both Configured as Active/Active (8+ databases <100GB total)
How can I get the DB's (all) from Site A and allow a DIFFERNET cluster to control them.
Basically, I want to move all DB's from "Site A" and bring them into "Site B" with all relevant data ..ie master DB etc . I have a time window of 90 Mins and I cannot lose one single piece of data.........( I need to lie down now)
Help would be apprecitated)
View 1 Replies
View Related
Aug 3, 2015
We have an HA configuration with an Active-Passive Cluster / Shared Disk SAN which is working great. I have been looking for how to replicate the information to our DR site. We have many databases (some are more static vs. other transactional). I had some questions:Would it make sense to configure a snapshot for the static databases? Is that possible from a clustered environment using it as the publisher?Would it make more sense to configure the clustered environment to use transactional replication? Is it possible from a clustered primary?Is log shipping too archaic?
View 4 Replies
View Related
Oct 25, 2015
Currently in my environment we are using SQL server 2012.We setup Alwayson with synchronous commit.Details of existing AlwaysOn: one primary and two secondary.
Primary: On-Premise server.
Secondary1: On-Premise server.
Secondary2: Azure VM.
Requirement: We need to add Secondary3 New Azure VM on same AG with asynchronous mode or synchronous mode.
Or
We need to create one more AG on same DB and add the new replica with asynchronous.Is it possible above 2 option in this scenario? My cluster environment is Manual failover only not auto failover.
View 2 Replies
View Related
Jul 20, 2005
Cluster services gives the high availability needed - that is great.But I have never seen any discussion about what happens when a nodefails - what do you do to get everything back to the active-passivetandem.I imagine there is not much difference in terms of recovery procedurefor either active or passive node. So I'm just going to make up ascenario that we have encountered. The system hard drive (not theshared disk) on primary node fails. Cluster fails over to the passivenode. Following are the problems I have at hand:-After installing windows, I need to install driver and configure thepermission to access the SAN. There is no way I could do it since thesecondary node has exclusive access to the disks.-Imagine I got that working, is there anyway to install SQL so SQLwould know this server used to be the primary node and attach the DBand translog automatically-Finally, there is no proper way to apply SQL 2000 service pack 3a.Originally when the cluster was fully functional, the service pack wasapplied to active node and that automatically upgrades passive node.Now we have a machine without 3a and a machine with 3a alreadyinstalled. See any problem?Consider all of the above as this one big question: What is a properprocedure to restore a cluster when one of the node goes down? Whetherit's the active or passive node.
View 1 Replies
View Related
Sep 9, 2015
I have inherited two separate SQL clusters. One cluster instance is called DESQLSC1INST1 and the other is MKSQLSC1INST1.
On MKSQLSC1INST1 I can connect by using MKSQLSC1INST1, MKSQLSC1 and the IP address that the cluster is running on.
On DESQLSC1INST1 I can only connect using DESQLSC1INST1.
I have checked configuration manager but it does not show me how this is set up.
Is there another way to configure this?
View 2 Replies
View Related
Oct 13, 2015
We have 2 clusters, 1 running SQL 2008 on Windows 2008 R2 server and 1 running SQL 2000 on Windows 2003 Server. Because of a disaster with the disks, each of the passive nodes had to be rebuilt and Ive been asked to install SQL on the nodes.
Ive not done this before. Does this mean simply adding a new node to the cluster through the wizard? Or do I need to reinstall the entire cluster?
I think SQL 2000 is too risky as its unsupported, so Im going to resist that. But how should I approach the SQL 2008 Instance?
View 4 Replies
View Related
Nov 5, 2015
I am trying to cluster two sql node server on hyper-v both virtual and my situation is below :
two hyper-v host connected to vnxe storage
two hyper-v are mapped to 3 LUN ( SQL Data , SQL logs , Quorurm)
connectivity between hyper-v and storage direct fiber
three LUN are mapped to the virtual SQL01 and SQL02 as VHDX and configure it on virtual machine as IDE below is the picture
LUNs are presented to the guest SQL01 and SQL02 and visible through disk management
When create the fail over cluster i am not getting the disk to add them to cluster
Getting the below error when validate the storage :
No Disks suitable for cluster disks were found, For diagnostic information about disks available run the Validate config wizard’..
Also , regarding this LUN how i can make them shared on the host side ?
View 3 Replies
View Related
May 8, 2015
I am using SQL 2012 SE with clustering on Windows server 2008 R2. Now I want migrate it to windows server 2012 with minimal down time. So I want to evict the passive node and add a new node with windows server 2012 and install sql server 2012 SE on the new passive node and perform a failover(make the node with 2012 OS as active) and then evict the new passive node and add another node with windows 2012 and then do the same thing?
View 12 Replies
View Related
Mar 13, 2008
Hello,
We currently have a 2 node Active/Passive 2 named instance SQL 2000 cluster. We will be chaning the configuration to Active/Active, basically moving 1 instance to the passive node (so we can take advantage of the resources on the passive node).
We would also like to add 3 nodes to the cluster making it a 5 node SQL cluster. What we are thinking of doing is basically making it an Active/Active/Active/Active with the 5th server being passive. The question I have is will I be able to add and install the 3 new nodes without having to redo the SQL cluster? Should I install the two new active nodes with the default SQL instace or do I have to install SQL with named instances? (actually I think the named instances is the way to go but then I wouldn't be posting here if I was sure about the answer).
Thx!
-Albert-
View 2 Replies
View Related
Jan 8, 2007
We have set up SQL Server 2005 failover cluster with 2 nodes, on Windows 2003. I'm now trying to add Reporting Services. I don't see any documentation for how to do this. Is it similar to adding Analysis Services? If I use this command I'm not sure what to put in several paramaters:
start /wait c:<path-to-setup>setup.exe /qn VS=<my-virtual-server-name> INSTALL=RS_Server INSTANCENAME=MSSQLSERVER ADDLOCAL=RS_Server ADDNODE=n GROUP="Cluster Group" IP="111.11.11.11,<my-virtual-server-name" ADMINPASSWORD=xxxx SAPWD=xxxx INSTALLSQLDIR=c INSTALLSQLDATADIR=c RSACCOUNT=mmmxxxxx RSPASSWORD=<domain-user-psswd> SQLBROWSERACCOUNT=<mmmxxxxx> SQLBROWSERPASSWORD=<domain-user-psswd> SQLREPORTING=1
My question are for:
IP: do i just put the virtual ip and name here, or every ip in the node?
INSTALLSQLDIR: is c drive correct here, or what is this?
INSTALLSQLDATADIR: is c drive correct here, or what is this?
RSACCOUNT: is this correct, not in the example in document ms144259 and what should go here?
RSPASSWORD: same as above
SQLBROWSERACCOUNT: what goes here?
SQLBROWSERPASSWORD: same as above
Thanks so much for any help.
View 4 Replies
View Related
Feb 18, 2014
I´ve been reading that SQL Server 2012 Always On is dependent on having a Windows Failover Cluster setup. Is that correct ?
View 6 Replies
View Related
May 15, 2008
Friends -
Could any one of you provide steps for upgrading SQL Server 2000 cluster to SQL server 2005 cluster.
My environment is Windows 2003 server.
Appreciate your support.
Cheers
VSH
View 1 Replies
View Related
Aug 26, 2015
I'm getting the following error when I go to create a cluster in the Failover Cluster Manager in Windows Server 2008.
"The address 10.10.10.111 is not valid for its associated network"
I'm following the instruction in the book for the 70-462 exam. There was a step that had me create a DNS A record for the address sql-cluster.contoso.com. The IP address was mapped to 10.10.10.111. I'm not sure if this is the culprit but its the only time I used that IP address in the setup.
Below are 2 screenshots. The first screenshot is the error. The second screenshot is my DNS console.
View 7 Replies
View Related
