none
Reduce secondary (.ndf) file size after import RRS feed

  • Question

  • Hi

    When I create a secondary data file (.ndf) and move the previous day's data from production server (SQL2014) to the archive server (SQL2017), the secondary file size is 4 times of the file size in production. 

    I am using the below query to create the file group and the secondary file. I do have partition Scheme, Function

    ALTER DATABASE DB_TRANS ADD FILEGROUP DB_TRANS_FG_20191112
    ALTER DATABASE DB_TRANS ADD FILE (NAME = DB_TRANS_FG_20191112_F00', FILENAME = '\\..\DATA\DB_TRANS_FG_20191112_F00.ndf', SIZE =2679, MAXSIZE = 50000, FILEGROWTH = 86) TO FILEGROUP DB_TRANS_FG_20191112

    Any help is highly appreciated.

    Thank you

    Wednesday, November 13, 2019 8:15 PM

All replies