As part of a SQL Server deployment, 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 practice? 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 synchronized before executing, or do we need to prompt the DB to fully synchronize before the snapshot is taken (as part of the create snapshot script)?