Moving table to another data file

  • Hi..

    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? 

     

    Thanks for any input...

     

  • 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