Transfer data from one data file to another

  • 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.

  • 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" 😉

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply