No, I have no problem of moving the files. The crm database has only 1 mdf file and we need to split the tables into different data files (not one file). Is there a guide or best practice to move the crm tables.? Thanks.
You should be able to use a standard ndf or secondary database file to split off specific tables. Andrii is correct though, this is more an issue for how SQL handles it. The bigger part is just making sure that you aren't splitting tables,
an entire table needs to be present in a single file. So like splitting POA, and Asyncoperationbase over to another file. The CRM views with the exception of audit aren't setup to read from a split table.