In SQL Server 2005, can I take multiple db snapshots at the same time?
We’re setting up K2 and it requires that several databases be snapshoted before being backed up so that they are at the exact same point in time. Can I do this and how? There are a total of 14 databases that need backed up.
One Solution collect form web for “In SQL Server 2005, can I take multiple db snapshots at the same time?”
If you want them backed up at the exact same point in time, you could put them all into single user mode, back them up, and return them to multi-user mode.
The recommended maximum number of DB snapshots is approximately 10, and not intended to be used quite how you are proposing to use them.