Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bhunter1
Starting Member
4 Posts |
 Posted - 2002-02-27 : 11:31:17
|
| In my subscriber database, I would like it to be split out into file groups. That is easy enough. However, when replication fails every other week or for some reason has to be rebuilt, the snapshot will drop and recreate the tables in the Primary file group. Is there any setting anywhere that would allow me to specify that certain tables get applied to different file groups during the snapshot? If not, what are some ideas for a work around?Thanks, BJH |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-02-27 : 11:43:41
|
| The only method I know of that can move a table to another filegroup after it's been created is to (re)create its clustered index on the filegroup you want. This will move the data to that filegroup since leaf pages and data pages are the same in a clustered index. I don't know if configuring the table for replication will allow you to still do this though. |
 |
|
|
|
|
|
Creating replication with file groups