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
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
2017-07-18 (first published: 2015-10-16)
1,735 reads
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
A script that generates all the commands for installing a new database mirroring between two servers
2015-03-17
157 reads
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
This article provides a comprehensive overview of the ORDER BY clause within SQL window...
Want to build a data analytics foundation that transforms raw data into valuable business...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I'm using the below connection string using providing UserID and password on their respective...
Comments posted to this topic are about the item Knowing Your Total Reward