I just stumbled upon this and it made my night. I'm having to migrate from SQL server 2005 to 2012 and I want to do it right the first time. This helped immensely! Thank you!
Thanks for the fast response! It is transactional replication where we are replicating databases from 5 different servers to one replica server for reporting. I will definitely do some further research on this. I just had that thought as we are working on setting up another server (not using replication) right now, and this video made me think about that. Thanks Again!
Hi, Jason. Yes, clustering can work well together with replication. Unfortunately this is too big of a topic to tackle in a comment - the answers depend on the topology of the cluster and the type of replication involved. This is the point where you'll want to pick up some books on replication, or bring in an experienced consultant.
That was a nice presentation. I have a situation and hopefully you can suggest me on this with your valuable inputs. 1. SQL Server is already installed on 2 nodes 2. Windows Server 2012 Standard Edition 3. Common Storage 4. 1 LUN (eg. Database) What needs to be done: Two nodes needs to be clustered for MS SQL database using Microsoft Windows Failover Cluster. The Database LUN needs to be mapped to the Database cluster. Can this be done. If not, what is the alternative.
***** - Thank you for replying Well I have like 7 days for this activity. I would be really thankful if you can provide me any link or resource for this. I am not SQL savvy.
We currently have replication in place on some servers for reporting that we are wanting to put in a failover cluster. How difficult is it to keep that replication working in the event of a failover? Is this a case where we would want to upgrade to enterprose and use the availability groups, and use the read only instance?
I just stumbled upon this and it made my night. I'm having to migrate from SQL server 2005 to 2012 and I want to do it right the first time. This helped immensely! Thank you!
Thanks for the fast response! It is transactional replication where we are replicating databases from 5 different servers to one replica server for reporting. I will definitely do some further research on this. I just had that thought as we are working on setting up another server (not using replication) right now, and this video made me think about that. Thanks Again!
Very engaging and interesting way of presenting the concept so neatly! Great Job. Thanks!
Great primer on HA and clustering! I will share as "mandatory viewing" with my less technical Ops team members.
Thanks for the cool presentation. I got a better understanding of clustering.
Hi, Jason. Yes, clustering can work well together with replication. Unfortunately this is too big of a topic to tackle in a comment - the answers depend on the topology of the cluster and the type of replication involved. This is the point where you'll want to pick up some books on replication, or bring in an experienced consultant.
Very nice presentation. Quite informative. Thanks.
Excellent presentation. Thanks!
Great Information in an engaging way.
Love the drawings :)
Thanks. Very informative
You're awesome thanks a lot for the informative session.
Cheers... :)
That was a nice presentation. I have a situation and hopefully you can suggest me on this with your valuable inputs.
1. SQL Server is already installed on 2 nodes
2. Windows Server 2012 Standard Edition
3. Common Storage
4. 1 LUN (eg. Database)
What needs to be done:
Two nodes needs to be clustered for MS SQL database using Microsoft Windows Failover Cluster. The Database LUN needs to be mapped to the Database cluster.
Can this be done. If not, what is the alternative.
***** - Thank you for replying
Well I have like 7 days for this activity. I would be really thankful if you can provide me any link or resource for this. I am not SQL savvy.
Ohh that Dog entry at the end....
13:28 It's bad luck to make a unicorn sad, I'll do my best to make sure that doesn't happen.
We currently have replication in place on some servers for reporting that we are wanting to put in a failover cluster. How difficult is it to keep that replication working in the event of a failover? Is this a case where we would want to upgrade to enterprose and use the availability groups, and use the read only instance?
Wonder what the guy version of the unicorn would be. :)
LOL, unicorns, awesome.
Your dog's shadow entering the frame at ruclips.net/video/zHDk7f90Atw/видео.html : 🦖🦖