Wednesday, March 21, 2012

Error on mirroring snapshot

Hi guys, does anyone get this snapshot on mirroring. My mirror server had been down for 1 month+ and just up again. Then my principal server will automatic synchronizing with it. Once i create snapshot on the mirror server for checking whether it get the latest record, there's an error msg which shows 'The database must be online to have a database snapshot.' Then I leave it for 1 hour+ for synchronizing and then still the same. Can I get any solution of it? Thx for the assistance.

Best Regards,

Hans

The mirror needs to be caught up before a snapshot can be created on it. So it should be synchronized, not synchronizing.sql

No comments:

Post a Comment