Transfer data from one data file to another

• mssqlsrv

  SSCrazy

  Points: 2375

  More actions

  October 16, 2013 at 3:31 am

  #299198

  Hi Team,

  I am planning to transfer data from one file to another.

  I have 7 files in primary file group.

  Motive for transferring data is I have around 100 gb of free space in each data file and I want it to shrink. But shrinking will cause the fragmentation.

  I Have below concerns.

  1. Will fragmentation happen while data transfer.

  2. Do I need to put the database in single user mode.

  3. Transfer data from datafile 'A' to specific data file in other file group.

  4. Things to check after data transfer.

  Let me know if any other thing which I might have missed here.

• Perry Whittle

  SSC Guru

  Points: 234065

  More actions

  October 16, 2013 at 7:34 am

  #1658883

  mssqlsrv (10/16/2013)

  ---

  3. Transfer data from datafile 'A' to specific data file in other file group.

  data is only transferred between files in the same filegroup using the emptyfile parameter

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉