The tag has no wiki summary.

learn more… | top users | synonyms

4
votes
1answer
128 views

Where to put a database in case of IP failover?

I understand that to achieve some level of availability of an online application it is possble to organize an environment with a redundancy using an IP failover mechanism and switching between several ...
3
votes
1answer
115 views

Availability mode - manual failover mode, best practice for availability mode?

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 ...
2
votes
5answers
2k views

Setting up a Redundant Sql Server 2008 Configuration While Retaining High Performance and Minimal Downtime

We have a situation where we are moving to a new hosting facility and are attempting to configure our new database environment. However, none of us are formal DBA's so a lot of what we are doing is ...
2
votes
1answer
176 views

Which database?

We have to launch a new service in my company with a big database. And I currently don't have that much knowledge. We did a small preview of the service and our biggest table had more than 2 100 000 ...
2
votes
1answer
723 views

Mirroring not working after a server crash

I'm using SQL Server 2008R2. Last night, the host machine on which my mirror database was running basically went belly up. Thankfully the principle database was on a different host server and so was ...
1
vote
3answers
3k views

Why are my SQL Server 2008R2 databases not mirroring?

I'm trying to set up database mirroring in SQL Server 2008R2. I've taken a full backup and a transactional backup from my principal database and I've restored both WITH NORECOVERY. However, my mirror ...
1
vote
1answer
514 views

Is there a tool that can check the availability of an Oracle 11g database on a remote machine?

I'm configuring the boot sequence on a Linux box, and one of the startup applications is dependent upon an Oracle instance being available on a different box. I would like a bash scriptable tool to ...
1
vote
1answer
644 views

How do I set up active-passive database clustering between data centers?

I am looking to setup an active/passive database cluster between data centers using mirroring and/or log-shipping across these two nodes. My challenge is understanding High Availability (HA) and ...