Can you Mirror an sql database once its gone live?
Posted on 2008-01-31
I have a clustered SQL database running on SQL 2005. I've been asked to set up the mirroring of it. I know how to mirror, but what i was wondering was, can you successfully mirror a database once its live. Do both sides of the Mirror have to be the same before you start the mirror process?
The reason i ask is this: I'll take a backup of my DB, and restore it to another server, then i can backup my log files and restore them to the other server, BUT when i start the Mirror process off, the two databases will be inconsistent, will the Mirroring process be ok with this, and if so, how?
The last time i done a mirror, i done it on a pre-production DB and therefore had them offline before starting the mirror process which meant that they were exactly the same.
Thanks in advance for any advice