Mirroring

External Article

Simple Steps to Prepare Mirror Database for Mirroring in SQL Server

  • Article

To prepare a database for mirroring, you need to perform the following steps: Script the restore of the latest full database backup, script the restore of every transaction log backup that has been made after that full database backup, copy the full database backup and transaction log backups to the mirror server, and run the restore scripts on the mirror server.
In this tip I will walk through these steps and provide sample scripts to prepare a database for mirroring.

2012-06-20

3,662 reads

Blogs

A Front Door for the DBA Team – AgentDBA UI

By

AgentDBA began as a command line. That suits one DBA on one server, but...

Cleaning Up Azure MS Defender Billing

By

I have a few Azure subscriptions, which are fairly small and not used that...

Installing and Configuring containerd as a Kubernetes Container Runtime

By

This post shows you how to install containerd as the container runtime for Kubernetes...

Read the latest Blogs

Forums

LAYANAN BCA KCU PRABUMULIH Telp/Wa 08388333589

By Layanan BCA_24jam

Jl. Jenderal Sudirman No.14, Muara Dua, Kec. Prabumulih Tim., Kota Prabumulih, Sumatera Selatan 31121

Alamat Telp BCA KCP Siliwangi (+62) 838-4945-0961

By layanan 24jam BCA

Wa:083849450961 Jl. Jenderal Sudirman No.39, Krobokan, Kec. Semarang Barat, Kota Semarang, Jawa Tengah 50141

Alamat Telp BCA KCU SIDOARJO (+62) 838-4945-0961

By m4l4mt194

Wa:083849450961 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa Timur...

Visit the forum

Question of the Day

SQL Server Vector Support II

With regard to SQL Server 2025's Vector support, what is an embedding?

See possible answers