When I create a data file (.ndf) and move the previous day's data from production server (SQL2014) to the archive server (SQL2017), the the file size increased to 4 times of the file size in production.
I am using the below query to create the file group and the .ndf file.
ALTER DATABASE DB_TRANS ADD FILEGROUP DB_TRANS_FG_20191114
ALTER DATABASE DB_TRANS ADD FILE (NAME = DB_TRANS_FG_20191114_F00', FILENAME = '\\..\DATA\DB_TRANS_FG_20191112_F00.ndf', SIZE =2679, MAXSIZE = 50000, FILEGROWTH = 86) TO FILEGROUP DB_TRANS_FG_20191114
Any help is highly appreciated.