SQL Server 2005 sp2 database Mirroring problems

  • odanwada (1/10/2010)


    HI i also face the same error. I think once after restore the database you might have forgot to restore the transactional backup. Try this i hope it works. Reply me if it works fine.

    After database restoration on mirror Server in no recovery mode always restore latest transaction log backup of pincipal server database on Mirror server before start or configure Mirririong.

  • odanwada (1/10/2010)


    HI i also face the same error. I think once after restore the database you might have forgot to restore the transactional backup. Try this i hope it works. Reply me if it works fine.

    After database restoration on mirror Server in no recovery mode always restore latest transaction log backup of pincipal server database on Mirror server before start or configure Mirririong.

  • Hi Guys

    According to my concern this is network related issue.

    so,you must try to change the port number other than 5022 ....like 6000 etc..

    It should be work fine just try once

    principal port:6000

    mirror port :6001

    witness port :6002

    These are not mandator just i'm telling use different port's instead of default port.

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply