.::: How To Mirroring Microsoft SQL Server 2012, 2014, 2016, 2018 & Trouble shoot SQL Server Error 1418, 1475,1478,1412 :::.:::

sample monitoring https://teguhth.blogspot.com/2023/09/monitor-mirroring-sql-server-using-t.html

 

Prerequisites

    For a mirroring session to be established, the partners and the witness, if any, must be running on the same version of SQL Server.

    The two partners, that is the principal server and mirror server, must be running the same edition of SQL Server. The witness, if any, can run on any edition of SQL Server that supports database mirroring.

.::: Create Database, Table and Entry Data, Check Database Size on Microsoft SQL Server 2012 Using TSQL :::.

When working with a command or query window, the language used by SQL Server is TSQL.

Step 1 -Create Database

Create a new database called teguhtrihartodb by entering the following TSQL then pressing the “Execute” button on the top menu.

CREATE DATABASE teguhtrihartodb;

GO

The Messages window on the bottom of the screen should say, ”Command(s) completed successfully.”