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 ...
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 ...
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 ...
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 ...