liam.north (1/15/2009)
I think the original question is slightly misleading; only files can be taken offline individually - there is no ALTER DATABASE statement to take a filegroup offline.
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.
Having said that:
- I agree the question would benefit from better wording
- thanks for a little extra info on the online/offline statements/functionality
Peter Rijs
BI Consultant, The Netherlands