Mirror Partner Agent Job To Auto Kick Back to Primary
Query the mirror instance via agent job to auto kick back to primary. If db is in suspended state will resume mirroring.
2016-01-05 (first published: 2015-12-23)
461 reads
Mirroring
2017-07-18 (first published: 2015-10-16)
1,760 reads
Database Mirroring Setup Procedure generator
A script that generates all the commands for installing a new database mirroring between two servers
2015-03-20 (first published: 2015-03-17)
948 reads
Database Mirroring Setup Procedure generator
A script that generates all the commands for installing a new database mirroring between two servers
2015-03-17
168 reads
Simple Steps to Prepare Mirror Database for Mirroring in SQL Server
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
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Ngagel Jaya Selatan No.Telp 083831617937
Whatsapp.083831617937 Jl. Ngagel Jaya Sel. No.25, Pucang Sewu, Kec. Wonokromo, Kota SBY, Jawa Timur...
BCA KCP Mulyosari No.Telp 083831617937
Whatsapp.083831617937 JL. Mulyosari, No.364 A Blok Z.56, 60113, Kalisari, Kec. Mulyorejo, Kota SBY, Jawa...
BCA KCP Mega Grosir No.Telp 083831617937
Whatsapp.083831617937 ITC Mega Grosir, Ground Floor Blok H2 No. 7-8-9, Jl. Gembong No. 20-30...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers