Lempster (1/15/2009)
I am probably being pedantic, but as long as no changes have been made to a database, it can be taken offline/brought online regardless of whether a snapshot exists - I've just tried it! Granted that is not a very realistic scenario as there would be little point in taking a snapshot if one knew that a database was not going to change.
What is prevented by a snapshot is a RESTORE of a database.
🙂
Well bligh me! I think that calls for yet another update to the BOL!
As I have no experience with snapshots, and also have no place to play around with them, I depended solely on the BOL for my answers on this matter.
To get to the bottom: as soon as there is 1 change in the source database, you can not get it back online after taking it offline with the snapshot in place?
Peter Rijs
BI Consultant, The Netherlands