Comments posted to this topic are about the item Accessing Mirrored Data
One Orange Chip
The statement that "snapshots generally take seconds to drop and create" is accurate. The key is generally. There are cases where creating a snapshot can take a very long time. You need to make sure that if you schedule automatic snapshot creation, it isn't done while there are long running processes, such as a large index rebuild, in mid-execution. Any open transactions in the database get "rolled back" in the snapshot as part of the creation.
You can read more about that here: Database snapshots can take a long time to create
Viewing 2 posts - 1 through 1 (of 1 total)