AS part of a SQL-Server deployment we are doing it was proposed to use Database mirroring as a redundancy option as well as allowing for Reporting and MI to be detached from the Operational DB.
the proposal is that we setup the database mirror using asynchronous mirroring and then at regular intervals create snapshots
however one line in MSDN states
To create a database snapshot on a mirror database, the database must be in the synchronized mirroring state.
how does this work in practise? and what does this mean exactly?
how often will the database be in a non-synced state? (in a relatively moderate volume workload Database (~50 users))
will a create snapshot script wait until the DB is synchronised before executing, or do we need to prompt the DB to fully synchronise before snapshotting (as part of the create snapshot script)