Mirroring- How to start the endpoint (mirror db)  if not able to recover transaction log backup from the primary?

Varshini S
Varshini S used Ask the Experts™
on
I have set up the server 2017 mirroring. And it does not have a witness server.
I have seen the below youtube video to know how to recover the DB during failover scenarios. Regarding this, I have gone through some articles too.

https://www.youtube.com/watch?v=HyGzgzRQCcI

If you want to use the mirror database you need to have transaction log backup from the primary server.  If you have multiple transaction log backups then you need to restore one by one in mirror server to activate.   How to start the endpoint (mirror DB)  if not able to recover transaction log backup from the primary?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Analyst
Commented:
How to start the endpoint (mirror DB)  if not able to recover transaction log backup from the primary?

You can follow the steps as described here http://sql-articles.com/articles/high-availability/how-can-i-bring-mirror-database-online-after-principal-server-is-down/ based on SQL Docs from https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-database-mirroring?view=sql-server-2017 however...

NOTE/CAUTION: This should be done only under severe Principal Server issues and assuming the data loss since last synchronization. Please do not attempt to test any of these in a production Environment as data loss is irreversible.

Author

Commented:
lcohan: Thank you, the article is more helpful.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial