https://blog.coeo.com/five-cool-things-you-can-do-using-partitioning Move files to another location without affecting the availability of the database. Rebuild part of our data using different compression/fill factor settings. Setting part of our data to be READ_ONLY. Quickly remove old data without incurring in high log usage. … Partial backups and restores.
Task: Designate all nodes as possible owners for DB01 and DB02 to ensure the cluster resource comes online automatically after a failover. Steps: To designate all nodes as possible owners for resources like DB01 and DB02 in a Windows Server Failover Cluster (WSFC), you can follow these steps. This ensures that the cluster resource comes... » read more
Create Index Progress Sources: https://dba.stackexchange.com/questions/139191/sql-server-how-to-track-progress-of-create-index-command/139225
Note: Run the SQLServer2019-KB5039747-x64.exe file to start the patch. An GUI similar to the SQL Server Install will popup to guide you through the patch process. Make sure SQL Server services has been stopped. Make sure to restart the server after the patch has completed. After the restart, the SQL Server version should reflect what... » read more
Create a Witness This sections shows how to create a witness. In the Failover Cluster Manager, locate the new cluster resource, right click, More Actions, Configure Cluster Quorum Settings. You Begin page of the Configure Quorum Wizard Choose “Select the quorum witness” Quorum Configuration Option page. This is where you will inform the Wizard which... » read more
Issues: SQL failover cluster automatically failing over. Windows Failover Cluster Log: Cluster node xxxxx was removed from the active failover cluster membership. The Cluster service on this node may have stopped. This could also be due to the node having lost communication with other active nodes in the failover cluster. Run the Validate a Configuration... » read more
Issue: All the sql job stuck in the state “Performing completion action” An AlwaysOn failure would sometimes cause this issue. A network glitch between SQL Server and Exchange Server can also cause this issue. Fix: Restart the SQL Agent service.
Microsoft regularly releases server or software updates to fix security problems, bugs in the software, and performance issues, or to add new features. These patches or updates are available on the Microsoft website. Microsoft regularly releases SQL server or software updates to fix security problems, bugs in the software, and performance issues, or to add... » read more
When running a validation test on a Windows Failover Cluster, drives may disappear from the cluster and file explorer if the cluster is hosting an Availability Group with iSCSI-backed disks. When you choose the default options in Validation – any storage that could be possibly shared storage is taken offline and brought into the cluster’s available... » read more
Look into the following logs… Critical Events from Failover Cluster Manager Validate Cluster Report Windows Event Viewer Quick Action: Update SQL Server to Latest Patch. Reboot server on all nodes. Critical Events from Failover Cluster Manager Cluster -> Nodes -> Show Critical Events Validate Cluster Report Cluster -> Validate Cluster -> Run all test Windows... » read more