I have a replication to a smaller box. It is used for reports only. Can I move the table to another data file within the same database, without killing my replication?
Never tried. With replication you won't be allowed to use any alter table sintax.
Maybe if you create a new file within the same filegroup and use dbcc shrinkfile. But I don't think you will be able to change to a different file group.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply