tl;dr; Filegroups are a logical construct used to separate tables and indexes from each other, files are the physical construct used to store information (log & data) about the database. When creating a database you’ll notice that each database is built of several components. There are two files, one for data and one for the…