SQL 2012 :: Create Failover Cluster Without Log Shipping

Jan 21, 2015

I am trying to create a failover cluster without the log shipping in 2012 as i've done it with a static instance with some database.Is the "AlwaysON" feature the solution when an application creates random and numerous databases within the instance and we need a failover scenario ?

View 9 Replies


ADVERTISEMENT

SQL 2012 :: How To Create Failover Cluster Using VMs

May 5, 2014

How to create a SQL 2012 Failover cluster using VMs?

View 9 Replies View Related

SQL 2012 :: Server Cluster Without Windows Failover Cluster

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

SQL 2012 :: Failover Cluster Using Virtual Box

Mar 29, 2014

I have virtualbox installed on my notebook. For testing purpose, is it possible to setup SQL Server Fail-Over cluster using virtual box? I don't have a shared storage. How can I simulate that?

View 1 Replies View Related

SQL 2012 :: Availability Groups And Failover Cluster Instances

Mar 21, 2014

I'm reading up on Always on and I am confused what is the difference between AlwaysOn Availability Groups and AlwaysOn Failover Cluster Instances.

View 3 Replies View Related

SQL 2012 :: Renamed Failover Nodes For Cluster And Broke It

Apr 17, 2014

I had a cluster running on 3 nodes (windows failover cluster) with server 2012 and SQL server 2012 running in the cluster. Well, I thought I'd just go ahead and rename all 3 of the hosts with new hostnames and it apparently broke the cluster pretty bad. Now when I open failover cluster manager I cannot see anything nor can I connect to the cluster object in AD. I re-named all of the hosts back to their original names but that didn't work.

View 5 Replies View Related

SQL 2012 :: Multi-Site AlwaysOn Failover Cluster

Oct 6, 2014

We are implementing a multi-site (Windows Server Failover Cluster) WSFC to enable Always On between our primary and DR site. We are not going to use SQL clustered instances. We are not planning to use shared disks. Each node is running a standalone instance of SQL 2012.

I have successfully configured a 3 node multi-site Windows failover cluster with no shared storage. For quorum, I have defined a File Share Witness (FSW). The FSW has voting rights and is in the DR site. The setup looks like this –

WSFC –

•Node A – Site #1 (voting right = 1)
•Node B – Site #1 (voting right = 1)
•Node C – Site #2 (voting right = 0)
•FSW – Site #2 (voting right = 1)

Again - There are no shared disks in our setup. We are not going to use SQL clustered instance. We are going to use Always On with these 3 nodes.

SQL Always On –

•Node A – Site #1 (Primary Replica)
•Node B – Site #1 (Readable Secondary)
•Node C – Site #2 (Readable Secondary)

All the setup including the “availability group” works properly under this setup. However, a failover to site #2 under DR situation is not working and I know why but don’t know what needs to be done to fix the problem.

The following works fine –

•Automatic failover between nodes A and B (same site – site #1)
•Forced failover to node C in site #2 provided at least one of the nodes in site #1 is up (non – DR situation) - this will ensure the cluster is up

The following is not working –

•Forced failover to node C in site #3 when both nodes in site #1 are lost (true DR situation) – This is because the cluster is not up at this point.

I know I have to bring the cluster up somehow and I have not been able to do so by restarting the cluster service.

I tried to run the command to start cluster service.

Question –

How can I FORCE the cluster to come up in Site #2 on node C when it has no voting rights?

I have always worked with even number of nodes and shared disks with traditional clustering. I am not sure what needs to be done in this scenario with 3 nodes and a FSW.

View 3 Replies View Related

SQL 2012 :: AG - How To Find Cluster Failover Count In AlwaysOn

Sep 30, 2015

How can we find the cluster failover count in always on ?

As my AG is configured as synchronous mode , AG went offline and we manually restarted the AG service when we check the properties on AG role they r in default setting ?

View 0 Replies View Related

DB Engine :: Server 2012 Failover Cluster New Instance

Aug 6, 2015

I am new to SQL Server 2012 clustering.I added a new instance to one of the two nodes.when I try to move it to the other node it fails.Do I need to install it on both?If so, what options do you install on the second node?

View 7 Replies View Related

SQL Server 2012 :: Remove Named Instance From Failover Cluster

Oct 13, 2014

In QA we have a two-node cluster with four instances of sql. In trying to add a fifth, I was given an IP address already in use so the install hung.

I removed it from the cluster but it is still there in the registry etc on the node I was working on.

I read about using the maintenance tab of the sql server install to "remove a node" but the terminology is confusing. To me a node is a physical server and an instance is an instance of sql server -- not the same at all but they are often referred to as the same thing.

I definitely don't want to remove one of the servers from the cluster.

View 1 Replies View Related

SQL 2012 :: Failover Cluster Install Hangs On Remote Machine Discovery

Feb 18, 2015

I am trying to install SQL Server 2012 onto an already configured and validated windows failover cluster (server 2012) but the process is hanging after installing the setup files.

The last entry in the log is:

running discovery on remote machine

and I've left it hanging like this for 4 hours and nothing happens.

View 2 Replies View Related

SQL Server Admin 2014 :: AlwaysOn Failover Cluster Session Failover

Oct 29, 2015

1. Once fail over to secondary replica, what will happen to connected session in primary node? can the session fail over to secondary seamlessly or need to re-login. what happen committed transactions which has not write to disk.
2. Assume I have always on cluster with three nodes, if primary fails, how second node make write/ read mode.
3. after fail over done to 2nd secondary node what mode in production(readonly or read write).
4. how to rollback to production primary ,will change data in secondary will get updated in primary.

View 5 Replies View Related

Recovery :: AlwaysOn Failover Cluster And Active Sessions Failover Scenario

Oct 29, 2015

1. In alwaysON fail over cluster, Once fail over to secondary replica, what will happen to connected session in primary node? can the session fail over to secondary seamlessly or need to re-login. what happen committed transactions which has not write to disk.

2. Assume I have always on cluster with three nodes, if primary fails, how second node make write/ read mode.

3. After fail over done to 2nd secondary node what mode in production(readonly or read write).

4. How to rollback to production primary ,will change data in secondary will get updated in primary.

View 3 Replies View Related

SQL 2012 :: Create Linked Server With Failover Partner Option?

Jul 22, 2014

it is possible to create Linked server with Failover partner option. I can query when primary server and getting the error when I set the DB Fail over. I have tried with following script and also gone through different sources, but failed. Please see the script and error below.

EXEC master.dbo.sp_addlinkedserver
@server = N'MIRRORLink',
@srvproduct=N'',
@provider=N'SQLOLEDB',
@provstr=N'Server=primary;FailoverPartner=mirror;network=dbmssocn;',

[code].....

View 2 Replies View Related

Log Shipping: How To Failback After A Failover Log Shipping?

Jun 8, 2006

Hi,

I 'm sure I am missing something obvious, hopefully someone could point it out. After a failover log shipping, I want to fail back to my inital Primary server database; however, my database is marked as loading. How can I mark it as normal?

I did the failover as follow:

I did a failover log shipping from the 2 server Sv1 (Primary) and Sv2 (Secondary) by doing the following

1) Stop the primary database by using sp_change_primary_role (Sv1)

2) Change the 2nd server to primary server by running sp_change_secondary_role (Sv2)

3) Change the monitor role by running sp-change_monitor_role (Sv2)

4) Resolve the log ins - (Sv2)

5) Now I want to fail back - I copy the TRN files to Sv1 - use SQL Ent to restore the database at point in time. The task is done; however, the database is still mark as loading. I could not use sp_dboption.

I appreciate any suggestion.

Thanks in advance

View 5 Replies View Related

Log Shipping Failover

May 25, 2006

Is it possible to failover a single or a selected number of databasesonto a standby server? We're currently log shipping about 12 databasesto a standby and I was wondering if it was possible to randomlyfailover onto selected dbs.My understanding of log shipping is that when the primary server goesdown, the standby takes over. But, does that mean that all of the db'son the standby server now become the primary? Or, can failover occur onselected dbs?The reason I ask is because if one db on the primary, for example, wasto go down, I'd like to be able to bring the particular db on thestandby server online while I fix or restore what's on the primaryserver. Can it be done individually or is it an all or nothingscenario?Your personal advice or links is greatly appreciated.Thanks,Peps

View 1 Replies View Related

Log Shipping Failover / Failback Question

Oct 12, 2006

Hello all,

I'm about to setup Log Shipping in our SQL Server 2000 environment. I will have the primary server, one standby server, and the witness server in this setup. I understand the process of failover and the stored procedures needed to make this happen, but my main question is about failback. Once the standby server has assumed the primary role, will log shipping be automatically configured to start flowing from the new primary server to the old primary server, or will I have to go back and setup log shipping from the new primary server to the old primary server?

Thanks for any help or insight you can provide on this subject!

Eric

View 7 Replies View Related

SQL Failover - Mirroring, Log Shipping, Clustering, Load Balancing

Jun 14, 2007



Hello.



I am confuse and cant decide on how to setup high availability on our SQL 2005. Here's what on my mind and on resources list:



I plan to have mirroring on my SQL1 to SQL2 with the help of SQL3 as witness. So this would be automatic failover. My idea on mirroring is when SQL1 goes down, SQL3 would tell SQL2 to run and be the primary. It will automatically failover to SQL2. Right? My questions are:

1) How can I revert back to SQL1 once it is ready?

2) I read in one of the post that it is impossible to write in a mirrored DB, is this true? I mean, what's the use of failing over to the next node when it's not possible to write and update data/records?

3) If number 2 is false (i hope so), how would the data be synchronize from SQL2 back to SQL1. Those transaction that were made while SQL1 is down.

4) How about the connection string from the web applications? Would it be automatically point to SQL2? We have load balancing setup in place, would this help web application connection to automatically point to SQL2?



Another setup:



We have SAN in place (not yet used, but is planning to use for this SQL thing), EMC to be specific. My question would be:

1) For SAN setup, the data storage would be centralize. So would that mean that SQL1 and SQL2 services will use the same data and log file from the SAN storage?

2) How would you call this setup then? Can this be clustering type of high availability? Will clustering work under load balancing setup? I believe mirroring is not possible here? Right?

3) How can I setup my 3 SQL servers with the same theory in mind: when SQL1 goes down, SQL2 will take over. Data will be synchronize when SQL1 is up and running again. With automatic failover and reverting back to primary.



I read so much topics about this, but the more I research, the more I get confuse.



Any suggestions, comments, advice is greatly appreciated!

View 6 Replies View Related

Cluster Failover ?

Oct 2, 2007

Hi I just set up a new cluster and everything was working. Now when I try to test failovers like unplug the public network card etc...

The cluster group fails over correctly but my data and log array's dont failover.

So I unplug the network cable from node 1 (active) the cluster group with the IP, name, and Quorum disk fails over to node 2 but the other groups sql data and sql log stay on node1 and dont failover.

Any ideas?

TIA

View 14 Replies View Related

Cluster Failover

Mar 9, 2007

Hi all:

I was wondering what will happend to the transaction when the cluster failover from one node to another?

In my case the database is in node-001 and I need to restart the server on node-001. So I need to have the database failover to node-002, so I can work on node-001. During this process, will it effect to end-user?

Thanks
vua

View 5 Replies View Related

Cluster Failover Testing

Feb 29, 2000

We need to start testing our Microsoft cluster servers.
Has anyone heard of any plan or products one can use to test
the failovers?
Please advise
Thanks
Susan

View 1 Replies View Related

Failover Cluster Not Using All Allocated RAM

Apr 23, 2007

We are running on SQL 2000 on Windows 2003. We have active-passiveclustering set up. We have 16 GB of RAM on each box. This pastweekend, we failed over. I noticed that the Total Server Memory wentfrom about 15.5 GB to 8 GB. I have been trying to figure out why thishas occurred. Any help would be greatly appreciated.

View 1 Replies View Related

SSRS On A Failover Cluster

Apr 9, 2008



We need to install the webservice and the database on a failover cluster. Our plan was to install the web service on node 1 and the database would naturally be on the cluster aware sql service. We know the RS will not be cluster aware and if node1 bites the dust, reports will be out of business.

We were planning to do this tommorow on development, but then found this little tidbit - read the very last paragraph

http://www.microsoft.com/dynamics/crm/using/deploy/clusteringssrs.mspx

SQL Server Reporting Services failover cluster configurations that are not supported

Do not deploy both SQL Server Report Services and the reporting services databases on each node of a multi-node cluster. Moreover, do not deploy SQL Server Reporting Services in a two-node cluster environment that consists of an active node and a passive node where the passive node becomes active during a failover.



They don't explain why not to do it - as if it will destroy your machine! This is our main dev cluster and we don't need it to go down.

We will not be installing the RS on each node, just one. But I was thinking that if the dns entry for the service points to N1, it will continue to function and make successfull DB calls to the sql server cluster name.


Could this work? I've found posts of people installing RS on both nodes and having success - but this would probably require another license...which we don't have.

Thanks so much for your help - it is greatly appreciated.

View 3 Replies View Related

SQL Cluster Failover/switch Notification

Nov 29, 2004

Hi all,

I need help to send notificaiton mails as soon as my active sql switch to passive one..

sp3a : 2000 Ent Ed.
windows 2003 Ent Ed.
Cluster: A/P


thanks in advance..

Regards
Deepak

View 1 Replies View Related

Applying A Hotfix To A Failover Cluster

Jan 25, 2008

Hi. Was hoping to get some advice on applying a hotfix to a SQL Server 2005 failover Cluster.

The hotfix I am applying (KB933508) relates to a Maintenance Plans issue with Server 2005 Service Pack 2. During installation I'm advised that unless the SQL Server and other services are stopped a reboot will be required, although I can still install the hotfix. However the installation is failing. There are error details in the relevant logs created in C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfix to the effect that the 'Debug' value in registry key 'SoftwarePoliciesMicrosoftWindowsInstaller' can't be read and that SQL Server was unable to add a user (the account under which SQL Server Agent and Analysis Services run) to a local group (the domain group in which SQL Server logins are contained).

Is this something simple like explicitly shutting down the services first before applying the hotfix or is there something else going on?

Regards,

YaHozna

View 8 Replies View Related

Failover, Cluster, High Availability

May 18, 2004

Hello,
Does any one know, any software out there that can provide a solid failover / cluster / high availability solution for SQL Server 2000 Databases.
I have tried Incepto but it requires an extra column in every single table that involves in Replication and its not gonna work

So Please advise.

Thanks,
imransi.

View 2 Replies View Related

Cluster Is Set To Sync And Auto Failover

Mar 12, 2015

I have a 2-node Windows Cluster and File Share Witness with an availability group. The cluster is set to sync and auto failover. I'm using SQL 2014 and Windows 2012R2. I'm trying to understand the steps to apply Windows Updates that require a restart. Are the steps something like this where ServerA is the primary replica and ServerB is the secondary replica.

Apply updates to ServerB.
Restart ServerB.
Fail ServerA availability group to ServerB using ALTER AVAILABILITY GROUP MyAvailGroup FAILOVER;. Server B is now the primary.
Apply updates to ServerA.
Restart ServerA.
Fail ServerB availability group to ServerA using ALTER AVAILABILITY GROUP MyAvailGroup FAILOVER;. Server A is now the primary.

What I don't understand is where Drain Roles on the Failover Cluster Manager fits in?

View 3 Replies View Related

One Node Could Not Up In Server Failover Cluster

Jul 23, 2015

We have 2 nodes window Server 2012 R2 and SQL Server 2012 Enterprise Version cluster setup. We can switch roles and Node to one node to another and revert back to previous node with out any issues. But we are facing when one Node is restarted. We could not restart that Node in cluster Service start in Failover cluster Manager. Error Details is displayed as below inside double code."Cluster node NODE1 could not to join the cluster because it failed to communicate over the network with any other node in the cluster. Verify the network connectivity and configuration of any network firewalls."

I checked windows firewall. windows firewall is all of in Node1, Node2, SAN and DC.I have disabled and enabled the Internal and private network of Node 1. I have validated the cluster. it is showing no error though.

Node1:
Public IP: 10.10.0.11
SubNet Mask:255.255.255.0
Default Getway: 10.10.0.1
Prefered DNS: 10.10.0.10 (Ip of DNS)

[code]....

Private Network: Not configured.pinging to each other ip is successful from one node to another.

View 9 Replies View Related

SQL 2005 Failover Cluster Installation

May 2, 2008

I noticed in installing a SQL2005 failover cluster instance,that it is not necessary to install on both servers. Installing on the primary node automagically installs to the secondary node. Does this constitute a COMPLETE install? It all seems to work. BUT this process does not intall client pieces (SSMS, for instance) on the secondary node. If you want that stuff there, do you then go to that box and just do a client install?

View 2 Replies View Related

Installing SQL Failover Cluster On SQL 2005

Dec 5, 2007

I am trying to install SQL failover cluster on one of my nodes so it should install sql on the 2nd node. It keeps coming back saying setup failed to start on the remote machine. When I look in scheduled tasks it is listed as could not run. Can someone please help.

View 1 Replies View Related

Transactional Replication And Failover Cluster

May 11, 2006

Hi All,I would like to set up transactional replication with failover cluster.Did anybody tried this? Does it work together? Is there anything Ishould be coutios when I set up these together? or Is there anyglitches?If somebody helps me I will really appreciate itThanks

View 1 Replies View Related

Failover Cluster Option Grayed Out

Aug 11, 2006

I have a mystery that I need a little help with.  I am trying to install SQL Server 2005 Std Ed. into a two node failover cluster running on top of Windows Server 2003 Enterprise Ed..   I have the cluster up and running.  It consists of an IP address, cluster name, a shared drive (E:), and an MSDTC resource.   When I run the SQL Server 2005 setup, the failover cluster option is always grayed out.  I have tried installing from the active node and from the cluster virtual server.  The result is always the same, no option to install a failover cluster.   Some suggestions would be appreciated.  I have read all the online docs I could find related to SQL 2005 failover clusters and found no clue.  

Thanks,

VARiflesmith

 

View 2 Replies View Related

Sql Server 2005 Set Up Failover Cluster

Dec 12, 2006

We have sql server 2005 installed locally on 2 servers and want to set up failover clustering. Do we need to uninstall what we have then install as failover cluster? Thanks.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved