Today by mistake deleted The AlwaysOn Availability Database from live server.
Let I am explaining the Details.
In AlwaysON Availability Groups, there is 2 Availability Replica. That is
Primary Replica Server (That is SQLServer1)
Secondary Replica Server (That is SQLServer2)
Primary Replica Server, there is 4 databases.
AlwaysOnTest Database2 Database3 Database4
In Secondary Replica Server (SQLServer2) , I can't say exactly because that is another SQLserver .But frankly i would like to say that i don't have access of that server.
When i got the accessibility of primary server it's already configured by Third party Vendor.
As a DBA my task was to take backup of all databases in
SQLServer1 . Also take backup of
AlwaysOnTest Database of Primary Replica Server(SQLServer1) is synchronize with Secondary Replica server (SQLServer2). This is only one database , which synchronize with secondary replica.
Today at 12:10 P.M at Qatar time by mistake AlwaysOn database deleted.
I have Full backup of Yesterday of Primary Server.
Note: The Backup Preference of Backup is
After instance I have also taken full backup of primary replica.
Now i want to again configure
AlwaysONTest Database with Secondary Replica.
Note: Only by mistake deleted AlwaysOn Availability database. The environment is as it is.
What i shall do . Any suggestion or help will be appreciated.