Robbert Hof (1/13/2009)
If you did not update your books online then you missed this one:...
Changed content:
Corrected technical error to clarify that you cannot bring a filegroup online when a database snapshot exists. [/i]
Missed 1 point 🙁
I use BOL from the MSDN site, and there it indeed states it cannot be done.
Since that is also the correct answer to this QotD, I don't get your point (no pun intended). Or did you yourself use an offline BOL (strange combination, if you think of it)?
Correct answer:
No
Explanation:
It is not possible. This is because bringing a file back online involves restoring it, which is not possible if a database snapshot exists on the database.
Ref: Limitations on Database Snapshots - http://msdn.microsoft.com/en-us/library/ms189940.aspx%5B/quote%5D
Peter Rijs
BI Consultant, The Netherlands