- 2 Windows nodes – Public
- 2 Private IP Addresses – Private
- 1 Windows Virtual Cluster Name
- 1 MSDTC (Optional)
- 1 SQL Server Virtual Network Name
- 1 SQL Server Analysis Services
This blog is to learn and share SQL DBA and Azure SQL knowledge among people by Bandaru Ajeyudu & Sudheer Thota
How many IP Addresses we require for setting up Active\Active SQL Server cluster with Analysis services?
How many IP Addresses we require for setting up Active\Passive SQL Server cluster?
- 2 Windows nodes – Public
- 2 Private IP Addresses – Private
- 1 Windows Virtual Cluster Name
- 1 MSDTC (optional)
- 1 SQL Server Virtual Network Name
SQL Server DBA: Database in Recovery Pending state
I have recently encountered an issue where one of the databases suddenly moved to Recovery Pending status after SQL Server fail-over.
I checked the database and it is in Recovery Pending status. Recovery Pending means that recovery cannot be started. Until the cause is fixed, recovery cannot run and the database cannot come online. I then checked the drives in the server and all drives are accessible.Then
Just i took database offline and bring back to online and database is automatically recovered.
OR
if multiple database are in recovery pending after SQL Fail over or SQL Server Restart..
I had to restart the SQL Server service manually and the database is automatically recovered.