SQL Server – Testing backups (part III)

Welcome to the final step of your future automatization 🙂 Quick reminder what we have done previously. This one forced me to learn new stuff – writing SQL queries and grabbing the results. It was fun to do 🙂 So the general idea was to create a script that will connect to the SQL server,…

Read More

SQL AlwaysOn – Step by step

Hello everyone, In this post, I will describe process of configuring AlwaysOn on SQL Server 2016. Always On availability groups feature is a high-availability and disaster-recovery solution for your SQL databases. Before you start with configuring, you need to meet some prerequisites. For successful implementation, you need: SQL Server Standard 2016, or older in Enterprise…

Read More

How to check installed SQL components

Have you ever had the need to install an identical SQL server what you currently have? Of course, you need information about the installed components, but you’ve wondered how to easily do so. You can do that on two ways, and each of them are pretty simple.   Solution 1: Open start menu / screen on…

Read More

How to transfer logins and passwords between SQL Servers

In one of previous posts, Mismatch SQL account SID, you see how to find account SID and create new SQL account with same SID. With that queries you can manually do that, but if you don’t know password, you will still have same problem – incompatible account between SQL servers in cluster. Also, if you need to “replicate”…

Read More