How to Upgrade or Patch Alwayson Availability Group Instances?
If you are planning to upgrade your SQL Server instance that hosts an Always on Availability Group (AOAG) to a…
7 years ago
SQL Server
How to Fix SQL Server Installation Error 1639?
Last week, I was installing SQL Server 2012 on one of the database server. Unfortunately, the installation was failed with…
7 years ago
Restore a Database Participating in Alwayson Availability Group
Sometimes, we need to restore a database that is part of always on availability group to fulfill our business needs.…
7 years ago
Fix SQL Server Msg 5144 and 5145 for long or failed autogrow of data and log files
Whenever you extend the size of your data or log file with a larger value or your database perform autogrow…
7 years ago
How to Add a New Database to Always On Availability Group?
Adding or Removing databases from availability group is not day to day task but we need to perform such activities…
7 years ago
How to Remove Database from Always On Availability Group?
This article describes how to remove availability database(s) from an Always on Availability Group by using SQL Server Management Studio…
7 years ago
Fix SQL Server Error 53: Could not open a connection on SQL Server
Today, I will explain how to fix SQL Server error 53 (The network path was not found). The details about…
7 years ago
How to Reduce PREEMPTIVE_OS_WRITEFILEGATHER Wait Type in SQL Server?
I was getting wait type PREEMPTIVE_OS_WRITEFILEGATHER during database size allocation. Yesterday, I was configuring database size to the value that…
7 years ago
Manage Transaction Log File during Data Load
Have you even face that your transaction log file is growing exceptionally and you have to manage log file to…
7 years ago
Fix SQL Server Installation Error: Attributes do not match
Last week I was working on SQL Server installation where i got this error Attributes do not match. Error details…
7 years ago