After DB migration, the database file keeps growing from 400G to 1024G. I check the real data from DB. In fact the real data costs around 400G. My DB recovery mode is simple. Transaction logs and Database files are located in separated locations. What had happened to my database? What shall I do for that? Do I need to shrink data files? As far as I know, SolarWinds recommends that you only shrink transaction log files. Do not shrink data files because it might result in fragmented indices, slow performance, data loss, and problems with writing data to the database. Why are there so many free space available？
