My Data & Log files are configured to be restored to the following path on this test instance: c:DataSQL16, but feel free to change them according to your test server. the years 1 data file (2007,2008,2009,2010). — Add 5 new filegroups. I am using SQL Server 2008 and a primary key of a database table I am using is not an IDENTITY column (not sure why). I need to change…