Introduction:
In this blog, we will discuss step by step that how we can repair MS SQL Databases. I already installed MS SQL Server 2019 on my computer. Now, we will study with MS SQL Server 2019.
The article will … Continue Reading
Category Archives: Windows SQL Server
ADFS3.0 Installation and Configuration with SQL Mirroring
ADFS is the one of the great feature and will cover how it is working in upcoming articles. Will see the installation and configuration in this article.
Okay., lets begin,
How to install ADFS with built-in Databases and configure has … Continue Reading
Not able to add Second Server in SQL 2014 Availability Group
When I am trying to add the Second Server for the SQL AlwaysON Group, I end up with following error
After Serious Search in Internet, Found the solution which resolved the above issue
After Serious Search in Internet, Found the … Continue Reading
Full recovery Mode is required Error
You may get the below error while you trying to enable AlwaysON for the Databases
To Resolve the Issue, Open the Database Properties
Enable the Full Recovery Model under Recovery Model which is Simple by Default. Now try to enable … Continue Reading
Not able to create the SQL Availability Group
Not able to create the SQL Availability Group getting Below Error,
To resolve the issue, Open SQL Server Configuration Manager
Under AlwaysOn high Availability and select Enable AlwaysOn Availability Groups
Once AlwaysOn is enabled, Restart the SQL Services
Now … Continue Reading