Category: mirroring

Mirroring best links collection –troubleshooting

below are the collection of best links and troubleshooting articles ,i came across so far

http://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-1130-database-mirroring-failover-is-instantaneous/

https://msdn.microsoft.com/en-us/library/ms187465.aspx

http://dba.stackexchange.com/questions/50514/failover-scenario-with-principal-hard-down

http://dba.stackexchange.com/questions/40609/can-i-shrink-the-transaction-log-file-on-a-mirror-database

http://stackoverflow.com/questions/3231765/why-is-msdtc-not-supported-when-using-sql-server-mirroring-automatic-failover

–author explains in simple terms why msdtc is not supported too

How to patch mirrored instances

best part of this answer is flowchart which shows what to do in upgrades scenario

http://dba.stackexchange.com/questions/58229/should-i-pause-mirroring-and-stop-sql-server-services-before-running-windows-upd

I will keep this thread updated on links which i found worth sharing

Advertisements