October 23, 2009 at 10:17 am
We are working on a future direction regarding replciation of our very large tables and how we can shorten the time to push a snapshot. Right now we are going to partition the table and have only one read/write filegroups with 1 to N read only filegroups that make up this partitioned table. Also, each partition will be on its own filegroup.
With that said, my boss is saying we should be able to detach the read only file groups and push the snapshot, which of course in theory would result in only the active data being pushed and all the old archived data on the other partitions can just be restored in place on the subscribers.
I have done a lot of research and cannot find anywhere where SQL Server 2005 or 2008 supports detaching of filegroups. You either detach the entire database or nothing.
Does anyone have any insight to this feature he swears exists?
Thanks in advance
October 23, 2009 at 11:18 am
AFAIK, this is correct. You cannot detach a filegroup, only a database.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply