I have a SQL Server 2014 database
DB01 (single filegroup - PRIMARY) and I took a backup of it into a
DB01.bak file in SSMS.
I have another database
DB02 with 1 primary filegroup (1 file) and one secondary filegroup (2 files). I am trying to restore the
DB01.bak file into DB02 with multiple filegroups. Is it possible to do this in SSMS?