Splitting database into multiple files

All replies

• 

  

  0

  Sign in to vote

  Hello,

  I believe this question mostly related to Microsoft SQL and not to Microsoft CRM. Check following links:

  https://social.msdn.microsoft.com/Forums/sqlserver/en-US/61c08bb2-e443-4ccd-89d8-34611b050522/split-one-mdf-file-into-several-files

  http://blog.idera.com/sql-server/performance-and-monitoring/increase-sql-server-performance-using-multiple-files/http://www.sqlpanda.com/2012/12/mssql-spilt-sql-server-datafile-to.html

  ---

  Dynamics CRM MVP
  My blog

  Monday, August 10, 2015 5:49 PM

  Moderator
• 

  

  0

  Sign in to vote

  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.

  Monday, August 10, 2015 6:05 PM
• 

  

  1

  Sign in to vote

  Why?

  ---

  The postings on this site are solely my own and do not represent or constitute Hitachi Solutions' positions, views, strategies or opinions.

  Tuesday, August 11, 2015 3:06 PM
• 

  

  0

  Sign in to vote

  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. 

  Thursday, August 13, 2015 2:06 PM