SQLTeam.com | Weblogs | Forums

Database mirroring issue


#1

Hello All,

I have a database mirroring set up and it's just showing the status as suspended. I tried to resume and it does not work. It stucked in suspended mode. Any ideas anyone, please helpppppppppp.

Thanks.


#2

Is there anything in the error log? It will often tell you what the issue is.

I've often had good luck stopping and starting the endpoint when nothing else seems to work.


#3

Also issues on the mirror like being out of space can cause this. Check the error log on both sides.


#4

Take a new backup from the primary and tail log backup and restore over the secondary with replace leaving it restoring then reinitialize mirroring.


#5

Please have a look on here to resolve database mirroring from suspended mode: http://www.techmixing.com/2016/09/how-to-resume-suspended-database-mirroring.html