Following is a short step by step procedure for failing over a MS SQL Mirrored Database: We are assuming the 1st SQL server is no longer responding and flipping the databases to be active on the 2nd SQL server. 1.) Obviously, log in with admin rights to the SQL Enterprise Management Studio [...]
Posted tagged ‘DR’
MS SQL – Failover a SQL Mirrored Database
February 1, 2011American Emergency Backup Strategy ;)
November 9, 2010You got to love the Americans for being over the top. This Emergency Backup strategy made me laugh! At least it is well documented.
More from IOD 2010: DB2 HADR
November 6, 2010Some notes from the recent IoD 2010 DB2 HA Session: > 2 modes when installing – DB2 Cluster Manager: 1.) Shared storage – install db2 on one node 2.) Database Partitioning Feature, DPF – Single partition between 2 partition x db2 resource groups Future is ‘Roving HA’ for Warehouse - Elimnates the need to failback – [...]
Setting up DB2 HADR
October 18, 2010Business Continuity and High Availability seem to be the at the top of customer priority lists at the moment. I previously blogged about the ability to use failover options on JDBC connections from within WAS. Continuing on from this I thought I would capture the high level points for setting up DB2 HADR for your CM8 or [...]
Updating your FileNet CE connectivity for AE
October 6, 2010PROBLEM: Presently, I am working on a HA FileNet environment utilising load balancers and SQL mirroring. After several attempts to connect to the FileNet CE from Workplace on the FileNet AE servers via a load balanced URL I decided there was a problem with the load balancer DNS entry but how did I prove it? [...]
ICC Configuration Manager failover
October 2, 2010I received a call this week to help a customer that had invoked DR at their site. Luckily we had designed a clustered ICC environment for the customer which meant that the extension node at their DR site had continued to ingest documents from their MS Sharepoint libraries. However, the problem lay with updating the [...]
WAS & JDBC Failover
September 28, 2010HA & DR are hot topics as always, particularly with our Finance customers. Here is a ‘neat’ and simple way to provide failover to a database mirror on WAS. We are creating a custom property for the JDBC Data Source. (MS SQL shown) Steps are as follows:
Tiered DR Solutions
September 14, 2010Different customers demand different Disaster Recovery, DR solutions generally depending how cash-rich they are. I came across the following which helps summarise what level of DR solutions a customer maybe aiming for. “The seven tiers of business continuity solutions offer a simple method to define current service levels and associated risks.” Tier 0: No off-site data – [...]
