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 ...
0
votes
1answer
148 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 ...
3
votes
1answer
270 views

Highly available and scalable SQL Servers with read-only databases?

I've been thinking about building a website which could potentially get a lot of traffic. It would be a research site of sorts with wiki capabilities. So users would be able to edit information on ...
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 ...
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 ...
2
votes
1answer
674 views

What are the advantages of async. database mirroring over transaction replication?

I've primarily a developer, but our organization is small, so I have been tasked with developing a HA strategy for our SQL servers. Currently, I manage our transactional replication to two additional ...
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 ...
1
vote
1answer
335 views

Biztalk 2009 logshipping with SQL 2008

I am setting up biztalk logshipping for Biztalk 2009 database. Following http://msdn.microsoft.com/en-us/library/aa560961.aspx article, I am doing the following to setup biztalk logshipping on ...
2
votes
3answers
208 views

HA suggestions for geographically separated sites

I have 6 instances of sql server that I need to be highly available by being hosted on two sites (one as principal, one as DR). Transparent automatic failover is required. Most are fairly boring and ...
0
votes
1answer
334 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
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 ...
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 ...
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 ...
3
votes
3answers
12k 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 ...
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 ...
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 ...
1
vote
2answers
136 views

SQL 2008 Clustering

I need to configure SQL or Windows 2008 Clustering to get HA with no packet loss. I configure my SQLcluster, but when I restart one node, I lose one ping. I try to lose no ping so that my query will ...