0
votes
1answer
95 views

SQL Server Virtual Network Name Change Error

I am in the process of configuring a two-node failover cluster for a migration project. We are transitioning a stand-alone SQL Server to a cluster. Environment: 2x nodes with Windows Server 2012 R2 ...
3
votes
1answer
57 views

High Available SQL Server without SAN by using AlwaysOn feature

I have two Microsoft SQL Servers (v 2012) and I want to make them mirror and when one of them goes down the second one will be replaced. AlwaysOn is a new feature in SQL Server 2012 that is ...
0
votes
0answers
76 views

Server infrastructure for busy e-commerce site built on MVC4 using MSSQL and Solr

What kind of server architecture do I need for this kind of application to make it more reliable. eCommerce application with abt 100,000 product with moderate to heavy traffic. The site performs very ...
1
vote
1answer
517 views

Load balancing with High Availability - SQL Server + IIS using AWS

This is my first time load-balancing with high-availability using Windows and SQL Server. Looking for some validation and input on my planned setup. Now, typically when I want to create a HA ...
4
votes
1answer
167 views

How does a SQL Server Availability Group decide on which secondary will become the new primary when an automatic failover is triggered?

How does a SQL Server Availability Group with multiple synchronous-commit secondary replicas decide on which secondary replica will become the new primary when an automatic failover is triggered? ...
1
vote
2answers
147 views

Improve automatic failover scenarios in SQL Server 2008

We have SQL Server 2008 set up in with a principal, mirror and monitor server, the mirror is synchronized and set to automatic failover. We recently saw a situation where we ran out of space on the ...
1
vote
1answer
500 views

SQL Server High Availability - Mirroring with MSCS?

I'm looking at options for high-availability for my SQL Server-powered application. The requirements are: HA protection from storage failure. Data accessibility when one of the DB servers is ...
2
votes
2answers
216 views

High Availability with 3 servers: To virtualise or not?

We're changing hosts for our SAAS app (IIS+MSSQL) and have an opportunity to redesign the infrastructure. Either stick with what we have (which works well) or virtualise with vSphere. Current: 2x ...
0
votes
1answer
127 views

MSSQL: High-Availability, Witness and Principal down case

The Setup is as follows: 1x Principal 1x Secondary 1x Witness If the Witness and Principal are gone (Hardware- or networkfailure), the secondary DB stays offline. I know this is by design. But if ...
0
votes
2answers
739 views

loadBalancing/clustering on IIS/ASP.Net/SQL Server

I've to create an offer for a future ASP.NET application. They wants an high availability(99.9%+). So I'm searching the best solutions with .Net technologies(asp.net mvc 3, IIS 7, SQL Server 2008 R2) ...
0
votes
2answers
302 views

SQL Server 2008 High safety: Is a buletproof configuration possible, in terms of data loss?

I'm designing a SQL Server architecture with two SQL servers and I'm planning to implement database mirroring between the two. I need to minimize the data loss in case of a server breakdown (whatever ...
1
vote
1answer
176 views

Site resilience with MSSQL Servers

What I'm trying to do is set up a failover system between two MS SQL Servers. It needs to be active/passive, and allow weighting (so Site 1 is preferable, before Site 2). I've done this between our ...
14
votes
7answers
2k views

When is the right time to introduce high availability for web site?

When is the right time to introduce high availability for web site? There are many articles on High Availability options. It’s not that obvious however WHEN is the right time to switch from single ...
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
2answers
272 views

High availability open source SQL database solution for Rails application

I'm researching a topic of high availability database for a Rails application. I'm looking for Open Source based solutions. At the moment our system is running on one application host + one db host, ...
1
vote
1answer
131 views

Swapping db's to increase availability during database update

I have a SQL server database with data supplied from a 3rd party. They supply a tool to update the database data weekly. The tool is pretty old and uses ODBC. The update can take several hours. In ...
2
votes
1answer
64 views

Installing two versions of MSSQL on a production server?

We've just provisioned a second dedicated server so we can use database mirroring for high availability. The existing server uses MSSQL Express 2005. We have MSSQL Web 2008 and want to minimise the ...
2
votes
8answers
871 views

How can 24X7 hours availability for an application be achieved?

I was asked this question in an interview: I have a sql server and an asp.net application. I want 24X7 hours availability for my application even if the server crashes. What are the different ways ...
0
votes
2answers
379 views

Tools to manage sql 2008 database mirroring?

We are going to be moving about 20 databases that live on a single instance of sql 2000 to a sql 2008 r2 environment with database mirroring. What I'm looking for is a tool or scripts that will help ...
2
votes
2answers
962 views

High Availability with 2 servers?

Is it possible to have a high availability setup with 2 servers? Running Windows Web Server 2008 and MSSQL Web Edition (as I know Express isn't supported)? Getting to the point where our one ...
6
votes
13answers
6k views

Move SQL-Server Database with zero downtime

Is it possible to move a sql server 2005 db to a different server running sql server 2008 without any downtime? The system is 24/7 and has to be moved to a different server with different storage. We ...
0
votes
3answers
565 views

How should I perform database maintenance on a 24x7 system

I'm a software developer who inherited a part-time DBA role. I'm responsible for an application backend by a small, high-volume 24x7 database on SQL Server 2008. While there's other stuff in the DB, ...
4
votes
4answers
286 views

High-availability system, how do I start?

I want to study about high-availability server, and then build a demo system (which contains HA web server - IIS, and a HA database - SQL Server ). I have some experiences about high-availability ...
2
votes
3answers
140 views

How to measure the time needed to switch a database mirroring role?

I want to measure the time needed for SQL Server to switch server roles. Is there a way to know how long does it take the mirror to become the principal and ready for new updates? Thank you very ...
2
votes
2answers
889 views

Use HAProxy to provide fault tolerance for mirrored SQL Servers

We are in the middle of building out our production environment for an upcoming web product. For this stack, a primary SQL Server 2008 will be used for live database operations and a secondary SQL ...
0
votes
1answer
127 views

Demo a database mirroring on SQL Server, which choice is the best?

I'm going to demo a high-availability SQL Server database to my mentor. My current PC configurations are: Pentium E6300 2G of RAM Windows 7 Ultimate I planned to create 3 virtual machines by ...
5
votes
2answers
4k views

High-availability on SQL Server, cons and pros of solutions?

I'm studying about high-availability on SQL Server for my thesis. I've learned there're several solutions to archive this: Failover clustering Log shipping Replication As I know, these solutions ...
0
votes
2answers
233 views

Good books on high availability database?

My thesis at university is studying about high availability database. Can you suggest me some good books on this field? I want to concentrate on SQL Server. Thank you!
6
votes
1answer
2k views

Does SQL server log shipping require a 2nd SQL license [duplicate]

Possible Duplicate: Can you help me with my software licensing question? I'm currently working on a high availability solution for SQL Server 2008. I have 2 servers with 1 license of ...
0
votes
2answers
118 views

Is replication suitable for this scenario?

The case: An industrial IT system, controlling and storing data on two production lines There is one server per production line. Each server runs the automation objects for that production line. ...
1
vote
4answers
606 views

SQL Server DR Strategies with virtualisation & multi sites

I'm looking for advice on the best HA/DR strategies for SQL Server. Currently I'm using Express edition with backups being copied over a the WAN to a remote site and being restored. The SQL Express ...
2
votes
1answer
4k views

Is SQL Server Mirroring Reliable (high availability)?

I'm evaluating SQL Server 2008 Mirroring (async) in order to provide better availability. I'd like to know, based on your experience, if SQL Server Mirroring is a reliable and mature technology. ...
1
vote
6answers
248 views

SQL Server 2000 High Availability

How do you implement high availability on SQL Server 2000? Are there any 3rd party tools out there or any other ideas?
5
votes
3answers
532 views

SQL Server clustering options

Can anyone give an high-level overview of the options available for SQL Server clustering, their pros and cons? Is it better to use Microsoft Clustering services or SQL Server native clustering? Does ...