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)
447 reads
Mirroring
2017-07-18 (first published: 2015-10-16)
1,735 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)
937 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
157 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
Mastering the ORDER BY Clause in SQL Window Functions
This article provides a comprehensive overview of the ORDER BY clause within SQL window...
SQL Data Pipelines: The Ultimate Guide to Streamlining Your Data Flow
Want to build a data analytics foundation that transforms raw data into valuable business...
Using SQL Compare in Read-Only Databases
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Logging from application to SQL server 2014..Using ODBC driver 18 for SQL SERVER
I'm using the below connection string using providing UserID and password on their respective...
Knowing Your Total Reward
Comments posted to this topic are about the item Knowing Your Total Reward