Hi Friends,

May i know what are the steps needed for Creating an Availability group and what are the prereq's that are needed before creating and how to add the Databases to AG.

You need to have

1) SQL Server 2012 and higher on Enterprise Edition

2) Windows Server Failover Cluster

3) Databases in FULL recovery model

4) Databases need to have at least one FULL database backup

Here's a video that shows you how you can configure an Availability

https://www.youtube.com/watch?v=A8lSl8nO1r4

https://msdn.microsoft.com/en-CA/library/ff877884.aspx?f=255&MSPPError=-2147217396

Hi KISIRI,

In addition to other post, you can add a database to an existing AlwaysOn availability group by using the Add Database to Availability Group Wizard , Transact-SQL, or PowerShell in SQL Server. For more details, please review the following article.

Add a Database to an Availability Group (SQL Server)
https://msdn.microsoft.com/en-us/library/hh213078

Thanks,
Lydia Zhang