2017-06-26
824 reads
Database Mirroring
Create EndPoint
Server principal 'xx\yy' has granted one or more permission(s). Revoke the permission(s) before dropping the server principal. (Microsoft SQL Server, Error: 15173). If you are gett
2016-10-03 (first published: 2016-09-16)
317 reads
Change operating modes for SQL Server Database Mirroring
SQL Server Database Mirroring offers two methods for exchanging data: synchronously and asynchronously. Sometimes there may be a need to switch between modes for an existing mirror and in this tip we will look at how this can be done.
2015-08-03
3,376 reads
2015-07-15
1,377 reads
Is Database Mirroring Causing The Transaction Log To Fill Up
In this article, I describe some steps a DBA can take to check for mirroring on SQL Server, give a status of the mirroring state and some options for resolving any problems with the transaction log that might be caused by Database Mirroring.
2014-11-06
4,043 reads
2011-10-13
2,074 reads
2011-09-21
1,992 reads
2011-09-09
2,139 reads
Configure SQL Server Database Mirroring Using SSMS
This tip outlines a test environment and then walks through the process of setting up Database Mirroring. This includes the configurations, backups, restores and verification process.
2011-09-02
3,660 reads
2011-08-31
1,993 reads
Blogs
The Constant and Constantly Changing Role of the DBA
I’ve been working in and around data for over 30 years now. My title...
Power BI Monthly Digest – June 2019
By Devin-Knight
In this month’s Power BI Digest with Manuel Quintana [Blog | Twitter] and I...
SQLSaturday Pensacola 2019 Coming Soon, See You There
One of my favorite (and my first) SQLSaturday events, Pensacola is this weekend June...
Forums
What's the CMK?
Comments posted to this topic are about the item What's the CMK?
Spread the Word about Basic Security
Comments posted to this topic are about the item Spread the Word about Basic...
ssrs 2012 subreport is running really slow
I have an existing ssrs 2012 report that is running really slow this year....
Ask SSC