tag:blogger.com,1999:blog-8769980932654813319.post4155770433727854754..comments2024-02-27T20:47:17.175-08:00Comments on MSSQL SERVER DBA's Paradise: AlwaysOn Availability Groups: Step by Step SetupGanapathi Varma Chekurihttp://www.blogger.com/profile/07125530325790202743noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-8769980932654813319.post-14818343951497993312017-09-28T04:06:33.773-07:002017-09-28T04:06:33.773-07:00SQL cluster installation works only on shared driv...SQL cluster installation works only on shared drive. Based on your requirement, you can install standalone instances of SQL Server and enable always on availability groups for SQL HA. Yes for always on AG, both instance should be of Same edition i.e.. Enterprise edition onlyGanapathi Varma Chekurihttps://www.blogger.com/profile/07125530325790202743noreply@blogger.comtag:blogger.com,1999:blog-8769980932654813319.post-75859540892900977362017-09-28T04:04:22.381-07:002017-09-28T04:04:22.381-07:00Glad you liked it. Please share and subscribe.Glad you liked it. Please share and subscribe.Ganapathi Varma Chekurihttps://www.blogger.com/profile/07125530325790202743noreply@blogger.comtag:blogger.com,1999:blog-8769980932654813319.post-90218538981321902262017-06-26T09:53:02.063-07:002017-06-26T09:53:02.063-07:00Hi Ganpati,
I have a query, We hare a requiremen...Hi Ganpati, <br /><br />I have a query, We hare a requirement to have SQL high Availability without Shared Drive. With reference to your blog we have configured Windows Failover Cluster on both the servers. Now the question is :<br />1. What installation type we have to use during installation Standalone or SQL Cluster Node installation?<br />2. If we go for SQL Cluster Node installation we are getting error like " No Storage Device" on Server.<br />3. If standalone both SQL servers instance need to keep same?<br />Please suggest which option we have to select.<br /><br /> Anonymoushttps://www.blogger.com/profile/12594465778208555433noreply@blogger.comtag:blogger.com,1999:blog-8769980932654813319.post-58203846524681214512017-06-15T00:53:47.899-07:002017-06-15T00:53:47.899-07:00HI Ganapati,
Its AWSOMEEEEE...Thanks man.HI Ganapati,<br /><br />Its AWSOMEEEEE...Thanks man.Anonymoushttps://www.blogger.com/profile/16569517262807176762noreply@blogger.comtag:blogger.com,1999:blog-8769980932654813319.post-23556523490442063482017-05-09T22:53:43.823-07:002017-05-09T22:53:43.823-07:00Hi Rajan,
No. it is a standalone instance and you...Hi Rajan,<br /><br />No. it is a standalone instance and you have to add database into availability groups. <br /><br />HA availability group is a group of databases that fail over together.<br /><br />https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/overview-of-always-on-availability-groups-sql-server<br />Ganapathi Varma Chekurihttps://www.blogger.com/profile/07125530325790202743noreply@blogger.comtag:blogger.com,1999:blog-8769980932654813319.post-38513787395890843642017-05-09T22:10:54.972-07:002017-05-09T22:10:54.972-07:00Hi Ganapathi,
It is again very nice article.
W...Hi Ganapathi,<br /><br />It is again very nice article. <br /><br />When we create an AlwaysOn, will it create a separate instance and database? Sorry it may be silly. <br /><br />Regards<br />RajanRajanhttps://www.blogger.com/profile/01171620446294150404noreply@blogger.comtag:blogger.com,1999:blog-8769980932654813319.post-58593926590286184912017-04-17T21:54:54.832-07:002017-04-17T21:54:54.832-07:00Yes it supports only one replica. Basic availabili...Yes it supports only one replica. Basic availability groups enable a primary database to maintain a single replica. This replica can use either synchronous-commit mode or asynchronous-commit mode.<br /><br />To know limitation of basic availability group check below article.<br /><br />http://mssqllover.blogspot.in/2015/12/sql-server-2016-alwayson-availablility.html<br /><br />Ganapathi Varma Chekurihttps://www.blogger.com/profile/07125530325790202743noreply@blogger.comtag:blogger.com,1999:blog-8769980932654813319.post-63827029209432270492017-04-17T09:45:45.940-07:002017-04-17T09:45:45.940-07:00Hi got a question on this "Always on availabi...Hi got a question on this "Always on availability groups is only supported in Enterprise edition starting from SQL server 2012 ( except SQL 2016 it supports basic availability group in standard edition)" what I read it says that on Standard it's up to 2 nodes but that mean it's only the failover cluster part???Danteshttps://www.blogger.com/profile/17266922955538967465noreply@blogger.com