-
March towards SQL Server : Day 20 – SQL DBA Interview Questions Answers – Always ON – 2
I hope you enjoyed my last post on Always On. Here goes the final post on Always On feature. What is availability group wizard? Availability Group Wizard is a GUI using SQL Server Management Studio to create and configure an AlwaysOn availability group in SQL Server 2012. What are the Restrictions on Availability Groups?…
-
March towards SQL Server : Day 14 – SQL DBA Interview Questions Answers – Log Shipping
This blog is about one of the High Availability feature supported by Microsoft SQL Server- Log Shipping. What is High Availability in SQL Server? A high availability solution masks the effects of a hardware or software failure and maintains the availability of applications so that the perceived downtime for users is minimized.SQL Server high-availability solutions…