0
votes
0answers
39 views

SQL DTC Failover Scenario

We had an interesting scenario in our clustered production environment last week. SQL 2008/R2 two boxes clustered on Win 2008/R2 in Active/Passive mode. On the active node A, the clustered MS/DTC ...
0
votes
1answer
156 views

HA Options for Windows Servers

We are looking at different options to allow us to stay up and running when our primary datacenter (DC1) goes down for any reason. What is the main difference in having a offsite server updated all ...
0
votes
0answers
54 views

SQL Server 2008 failover clustering

Yesterday a power surge took out our SQL Server. Had to have the motherboard replaced and everything. Not good. Anyway, I'm now looking into failover clustering to prevent such an event from ...
0
votes
1answer
195 views

SQL Server Web Edtion Failover Cluster

Is it possible to run an SQL Server Web edition in a Windows 2008 R2 Failover Environment? I want to host a Website with backend database but keep it failsave with a failover cluster (install it on ...
0
votes
1answer
187 views

SQL connection with mirroring still working after a failover

I have a windows service application that is instaled on two servers, SQL01 and SQL02. On both server there is a SQL server (X1 and X2), which have the same content. A mirroring partnership was set up ...
1
vote
1answer
371 views

Implementing Automatic failover with SQL Server 2008 R2 Web Edition

I am trying to implement automatic failover for an ASP.NET MVC website running on Windows 2008 R2 Web Edition / SQL Server 2008 R2 Web Edition. I know that this is not supported out of the box, but I ...
4
votes
1answer
157 views

What is the best way to replicate a large number of SQL 2008 DBs to a failover instance in Amazon Web Services

Our application creates a new sql database for every customer and we will be continually adding new customers and creating new databases every day. These databases can range in size from 3 megabytes ...
3
votes
3answers
2k views

How to: Hot Standby SQL Server in another datacenter?

For our SaaS app, I want to have a system in place for a datacenter wide failure. In the main datacentre, we have two servers set up with MSSQL Database Mirroring (synchronised). This provides us ...
0
votes
1answer
336 views

Best solution for High Availability and SSRS on SQL Server 2008 R2?

I have 2 Physical Servers with SQL Server 2008 R2. – SQL Server 1(Active) & SQL Server 2 (Passive) Web Application is developed using .Net 4.0 Framework. I want to know the best solution to have ...
1
vote
2answers
169 views

Sql Server 2008 Database Mirroring

I'm at the early stages of implementing a high availibilty solution using SQL 2008. With regard to database mirroring I believe that under the syncronous model, transactions are not committed on the ...
1
vote
1answer
847 views

Add second ip address to an existing SQl 2008 failover clustering

I have a failover cluster on Windows Server 2008, with SQL server 2008. On each server I have two network cards, with two different networks. One is on 10.10.10.x and the other is on 192.168.99.x I ...
3
votes
3answers
13k views

SQL 2008 Mirroring, how to failover from the mirror database?

I have configured a database mirroring setup in SQL 2008 using the High-safety, Synchronous mode, without automatic failover. I don't have a Witness instance. Regarding high availability, I ...
2
votes
1answer
422 views

Intermittent unavailability of an instance in a failover cluster while a standby node is offline in a SQL Server 2008 failover cluster

I've got a small failover cluster that I run for the websites my company has. During a RAM upgrade of the standby server, our websites started to show errors about not being able to access the ...
1
vote
3answers
137 views

Best way to duplicate databases nightly?

We just got two new servers, that are running Windows Server 2008. The intent is to make the machines pretty much identical, copying the content of the master to the slave on a nightly basis, so that ...
1
vote
1answer
768 views

SQLServer 2008 FailOver and Load Balancing

I have a project with a 2TB database ( 450.000.000 rows). I need to provide to the project a solution that gives FailOver and load Balacing, what do you recommend? We are going to use a NetApp Filer ...