Calling all DBA guru's!
Need some assistance - right now we have a SQL 2012 server running on SP2 with about 9 databases (so far). We want to setup HA and DR for this box. We were thinking of setting up another SQL 2012 box in the same site, naming it SQL 2012 NODE 2 and renaming the production one SQL 2012 NODE 1. Then put both of these in a AlwaysOn Group in the same site. Once this is setup, log ship from the primary node to a DR site.
Thoughts? We currently do this for another environment but I also wanted assistance with getting my head around its configuration. I can supply screen shots etc..