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 New Word: Dorgone

By

dorgone– adj. wondering if you could slip away from an event or group conversation...

Tell It Once: Setting Up Claude With Skills and MCP Servers

By

Many of us use AI the same way every single day. Open a tab....

SQL Server Transaction Log Forensics: Preserving Evidence During an Incident

By

SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...

Read the latest Blogs

Forums

does anyone used https://github.com/ktaranov/sqlserver-kit

By ARUN KUMAR AGUNURU

Could you please let me know if anyone is used https://github.com/ktaranov/sqlserver-kit github for deployment...

How Can Database Performance Improve the Overall Website Experience?

By Brooks-Hayward

I’ve been looking into ways to improve the connection between a website and its...

When And How to Automate?

By AndrewGuard

Comments posted to this topic are about the item When And How to Automate?

Visit the forum

Question of the Day

Hyperscale Replicas II

How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?

See possible answers