-
AlwaysON Issues
Quarantined nodes in Windows Failover Clusters: I’ve observed this issue on Windows Server 2016, where one of the nodes were quarantined after many node failover attempts in an hour. For the following few hours, the WSFC prevents the node from rejoining the cluster. This could be due to a network issue that I’ve noticed in […]
-
Restore All Databases from Backup Path Using DBATOOLS
I had a circumstance where I needed to restore 100’s of databases from a source server to a destination server, and we had to do it manually one by one, or manually build restore scripts for all databases using T-SQL scripts, or automate the process using PowerShell. I’m planned to use PowerShell to move the […]
-
Automate Migrating Databases From Source to Destination USing PowerShell
Using a combination of PowerShell and T-SQL scripting, create a simple solution for automating database migration across SQL Server versions. In my instance, I need to locate multiple databases that can be migrated using a standard procedure or at the very least a set of standard activities before proceeding to a set of customized actions. […]
-
Starting and Stopping All SQL Server services on a server with PowerShell
Suddenly, I received a request to shut down a number of SQL Server instances in order to relieve some load. A lot is defined as 60 or more instances spread across 30 servers. Manually logging onto each server and stopping services is a massive chore, especially because some servers have numerous instances. So I decided […]
-
Troubleshoot Missing Of MSI or MSP files using FixMissingMSI tool
If you’ve ever had troubles with missing cached MSI/MSP files during SQL server setup, you might be familiar with the following article:How to fix difficulties that occur during a SQL Server update by restoring the missing Windows Installer cache files. https://docs.microsoft.com/en-US/troubleshoot/sql/install/restore-missing-windows-installer-cache-files The above link has a VB script that will assist you in locating lost […]
Sri's SQLDBA Blog 