By Ginger Daniel | Intermediate , SQL Administration , SQL Maintenance , SQL Server
— by Ginger Keys SQL Server AlwaysOn provides a fairly robust environment for disaster recovery; however you can never be too careful when it comes to technology and protecting your data. Regular maintenance routines (i.e. backups, etc.) need to be set up and performed on an ongoing basis, even when you have your databases in […]
Continue readingBy Ginger Daniel | Beginner , Miscellaneous , SQL Administration , SQL Server
–by Ginger Keys AlwaysOn Availability Groups made its debut in SQL Server 2012 as a new feature that enhanced the existing technologies of database mirroring and failover clustering to provide an option for high availability and disaster recovery. AlwaysOn gives you the ability to scale out several secondary Servers (replicas) for high availability or […]
Continue readingBy Lori Brown | Intermediate , Miscellaneous , SQL Administration , SQL Server
— by Lori Brown @SQLSupahStah While trying to add a database to an existing AlwaysOn Availability Group (AG), I was having difficulty making a connection from the primary replica to the secondary replica. The availability group was functioning but as I tried to add a database to it, my connection to the secondary replica was […]
Continue readingBy Lori Brown | Helpful Scripts , Intermediate , SQL Administration , SQL Server
— By Lori Brown @SQLSupahStah After reading up on AlwaysOn Monitoring and Alerting (http://blog.sqlrx.com/2015/08/27/alwayson-monitoring-and-alerting/), I was asked to come up with a way to automatically enable jobs that may only need to run on the primary replica of an availability group. Requirements were that on failover of an AlwaysOn Availability Group some jobs should be […]
Continue readingBy Ginger Daniel | Helpful Scripts , SQL Administration , SQL Server
–by Ginger Keys AlwaysOn Availability Groups is a great new feature of SQL 2012 and 2014. This feature is a combination of database mirroring and failover clustering, and it provides a strong level of high availability and disaster recovery; however there is no straightforward monitoring/alerting processes to go along with this new functionality. It is […]
Continue readingBy Ginger Daniel | Installation , SQL Administration , SQL Server
After you make sure you have everything in your environment ready to go and all the prerequisites that need to be done before deployment have been done, we are ready to install the AlwaysOn Availability Group! The following steps need to be performed in this order: Add Windows Failover Clustering (WSFC) to each replica (server) […]
Continue readingBy Ginger Daniel | Installation , SQL Administration , SQL Server
Before implementing your AlwaysOn Availability Group, make sure you have everything in your environment ready to go. There are several prerequisites that need to be done to ensure a successful deployment. These prerequisites focus on your Windows environment, the SQL instances, and the databases to be included in your AlwaysOn group. Windows: Windows Server 2008 […]
Continue readingBy Ginger Daniel | SQL Administration , SQL Server
AlwaysOn is a great new feature in SQL Server 2012 and 2014 Enterprise edition. It has been described as the next evolution of database mirroring. AlwaysOn enhances the existing technologies of database mirroring and failover clustering to provide a strong layer of high availability and disaster recovery. The way it works is that you have […]
Continue readingBy SQLRx Admin | SQL Server
This article excerpt, by Johan Åhlén, originally appeared here: http://bit.ly/1dARmgI Just when we thought that nothing could get any better than SQL Server 2012, Microsoft announced news around SQL Server 2014. There’s even a SQL Server 2014 website where you can get a free trial. So, what’s new and cool? Hekaton In-memory Database Capabilities Hekaton makes it […]
Continue reading