Peter Rijs (1/15/2009)
I don't think that is misleading at all."...bring ... online if a snapshots is created on source database?": IMHO that would directly point to a NO, no matter whether file, filegroup or database is to be brought online.
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.
🙂