I really needs some help with Setting up SQL servers. We are re-configuring our network and have no clue how to resolve our SQL issue. My Network Admin. wants an "Active/Active" with shared storage ...

I have setup the 2 PostgreSQL 9.4 severs with master-slave(Hot standby streaming replication).Is this possible in pgpool-II 3.4 to configure,where it works for automatic failover(network or hardware ...

I read somewhere that MySQL can have a master / slave setup in which the master database can continue to run live and in production while the slave database can be turned off to snatch a backup. And ...

I have a multi-node server application that is backed by SQL Server 2012, often in a clustered or AlwaysOn AG/FCI HA configuration. My application monitors the health of the application nodes (not the ...

I intend to setup a high available for database system, I have 2 solutions here :
Set up a HA clustering with heartbeat and share storage for 2 nodes as master(to storage the configuration and data ...

I know it's cringe-worthy to use this term, but I have a SQL Server 2000 cluster with one clusetered instance running on it with multiple resources running on one of the two servers in the cluster all ...

I am considering to turn off the transaction safety to maximize the performance.
Before that i am interested in finding the current status of transaction safety. Is there any command that we can get ...

I have an application that is being run on two separate sites. Ideally they would share a database, because each application needs to see what the other is writing to the database.
However, the sites ...

First of all i have to say that this question comes from a software engineer-perspective. Unfortunately we have no DBA so we need to administer our own databases.
We have SQL Server 2012 Enterprise ...

I have the following:
Data Center (1) has a set of two Microsoft SQL Server databases. They are clustered using MSCS and shared NetApp storage FAS3250 system. This provides me with local fail-over / ...

With Mirroring being deprecated in SQL Server 2012 and up along with AlwaysON Availability Groups costing $7k per core, I am wonder what options are there for constant reliable backups with a somewhat ...

How do I see history of failovers of the primary node in cluster? I'm trying to figure out at what point secondary node started to act as primary.
We are running Windows Server 2012 with SQL Server ...

I'm a software dev with little experience managing SQL Server so please bear with me.
We are developing a piece of software that needs to be highly available, with a significant degree of resilience. ...

All, Thanks in advance
I have two instances of SQL Server 2012 SP1 on a three node WSFC with a HAdr group on each instance with a corresponding listener. Instance 1's listener points to Instance 1, ...

I am currently working on designing an architecture for High Availability in PostgreSQL for a database of approximately 5TB in size. Also, I would like to re-direct my reads to a slave node(preferably ...

I have SQL Jobs that need to only on primary replica on AlwaysOn Availability Group. When jobs were originally created ServerA was primary, at later point ServerB became primary so jobs that were on ...

We don't want automatic failover for our availability group, but I have set availability mode to Synchronous, was that a mistake?
The availability group runs on vmware with windows 2012R2, and I got ...

We're about to move from SQL Server 2008 R2 Standard to SQL Server 2012 Enterprise and are reviewing or HA as part of process. Right now we use DPM and log shipping every 15 mins. Our MS partner is ...

I need to setup database replication (for high availability) on a database that uses FileStream. This is on SQL Server 2012 Standard Edition, so Always On or Peer-to-Peer replication is not an option. ...