Tagged Questions
2
votes
2answers
18 views
Best high availability solution to avoid maintenance downtime?
We currently only have one production SQL Server 2008 server. Anytime we need to perform maintenance or install patches, it causes downtime as the server reboots. In addition, if the server ever ...
0
votes
0answers
24 views
Synchronization between master and backup server
I am searching for an option to synchronize data between production server and backup server automatically. Does somebody know a method, how I can do this:
if I delete, insert or update a record it ...
1
vote
1answer
38 views
PowerPivot doesn't install in SharePoint mode on an Active/Passive Cluster
We a provisioning a new SQL Failover Cluster. We have successfully configured the SQL instance, and have moved on to configuration of the PowerPivot for SharePoint instance. We run the configuration ...
1
vote
0answers
25 views
DPM and AlwaysOn - Can they work
How does AlwaysOn tie into DPM for SQL Server 2012? Can we use one or the other for High Availability ? Can they work together or must they be used separately. Thanks
0
votes
2answers
89 views
SQL Server sync databases between enterprise - web edition
We have an enterprise version of sql server 2012. we need to synchronize its data to a web edition database. what would be the best option t do this ? further to add on to this we need to provide ...
4
votes
2answers
171 views
SQL Server replication for off site copy
We have our Primary SQL Servers in-house (15 primary servers at the moment (500 databases approx overall), most of the servers have hex core processors).
These are mirrored to other backup servers in ...
6
votes
1answer
199 views
Recovery time effects of AlwaysOn
We did different kinds of basic Tests and AlwaysOn passed in many tests. We finally did a heavy write test for AlwaysOn and it gave surprising results.
The actual Test details are here, the goal is ...
2
votes
0answers
186 views
SQL Server connection with multiSubnetFailover fails, claims mirroring is enabled
I have two SQL Server instances in an availability group. They are not mirrored.
I'm trying to connect to the AG using the MS JDBC drivers (4.0) with a connection string including ...
1
vote
1answer
169 views
SQL Server 2012 AlwaysOn cannot connect using the Listener IP
I have setup a Windows network in an Amazon in a VPC. I have setup two SQL servers and configured Always On. Everything works OK, except that I cannot connect to the SQL Server using the AAG Listener ...
1
vote
0answers
276 views
SQL Server Database Mirroring : strange client application behavior upon failover
I am putting a HA SQL server environment up based on three SQL Server 2008R2 machines and database mirroring.
I'll name them :
principal.company.intra
mirror.company.intra
witness.company.intra
...
5
votes
1answer
474 views
Do schema changes “break” SQL Server 2012 AlwaysOn or are they handled transparently?
My organization is planning to adopt SQL Server 2012 AlwaysOn and I am trying to understand what impact (if any) it will have on our application upgrade process.
We release application updates on an ...
3
votes
1answer
375 views
AG and SQL Backups
I am using always on in sql 2012 and have an AG setup. I would like to know if i were to backup the primary database and restore it would that be allowed without taking the cluster down etc.
...
0
votes
1answer
134 views
AlwaysOn SQL Server setup questions
I just have a few questions regarding the setup of Always On HA, and Clusters. When you setup an AG, and it gets to setting up your IP address for the cluster how can i switch from using DHCP to a ...
7
votes
4answers
2k views
SQL Server equivalent to functionality of Oracle RAC?
I did some Googling and couldn't find an answer to this question more recent than a few years ago, so I thought I'd ask. Oracle's RAC feature offers load-balancing for both read and write ...
4
votes
1answer
223 views
Mirroring and Availability Groups in SQL2012
I've been looking at the new features of SQL 2012, and how it can help my current situation.
Currently we're on SQL 2008R2, and replicate two OLTP servers' databases to a single reporting server via ...
