• Thank you SQL Expertise..

    i tried Mirroring failover to verify the data is updated in mirrored database.

    it has come:-)