Database Recovery

How to Scan and Get Mirrored Databases in SQL Server

For setting a SQL Server database mirroring we need two SQL Server instance. These two SQL instances can be on the same machine or on different machine. In this article, we will learn how to get the list of all mirrored databases from our SQL Server environment. Scan for Always On This script would help you to scan your SQL environment and identify SQL Server databases that are part of mirroring. In this script, we would be connecting to each linked server from a Central server. Please do...

Read more »

How to Scan and Get Always On Enabled Servers in SQL Server Environment

Maintaining a SQL Server inventory is very important. Before performing a migration project, the inventory will help a database administrator to get more detail about that server. In this article, we will learn how to scan the entire SQL environment and identify servers on which Always on has been enabled. The Best Always on Availability Groups is considered as the best high availability, disaster recovery feature in Microsoft SQL Server. It is the highly-advanced version of database...

Read more »

How to Scan and Get Log Shipped Databases in SQL Server

"Log Shipping Alert" is a job category that is created on the SQL Server instance whenever the log shipping is enabled on a database. Though this might seem to be an easy way to identify if log shipping is running on a particular SQL server, through TSQL we can scan the entire SQL Server environment to identify databases that are participating in Log Shipping. 2 tables Log shipped databases can be easily identified using two tables in msdb database. The first table is the...

Read more »