Join Stack Overflow to learn, share knowledge, and build your career. Connect and share knowledge within a single location that is structured and easy to search. This query does not resume mirroring. Please list an alternative method to get mirroring running again.
SQL Server Wait Statistics (or please tell me where it hurts…)
MS SQL Server - Quick Guide - Tutorialspoint
Join Stack Overflow to learn, share knowledge, and build your career. Connect and share knowledge within a single location that is structured and easy to search. I've optimized my import application and I broke my mirroring, I'm pretty sure it's because of it. I get this error and I cannot resume it. Database mirroring has been suspended. Resolve the error on the remote server and resume mirroring, or remove mirroring and re-establish the mirror server instance. And also make sure you have both systems patched with most recent CUs.
MS SQL Server - Quick Guide
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up. Connect and share knowledge within a single location that is structured and easy to search. I paused database mirroring before I rebooted the Windows server, and I found that the database had resumed mirroring automatically after the reboot.
After configuring database mirroring, you can pause, resume, or remove database mirroring. If database mirroring impacts your applications performance, you may want to pause a database mirroring session and improve the performance. Pausing a database mirroring session causes the mirroring state to change to suspended. During this time the principal does not send any transactions to the mirror, and its principal database's transaction log keep growing, even if you schedule transaction log backups. The transaction log is not be truncated because it has to send the transactions to the mirror after the database mirroring session resumes.