SQL 2008r2 database
This database has some tables in one filegroup, some in another filegroup. Different filegroups are on different drives.
I have a database backup (bak) file of that database and I want to restore it somewhere else but I don't want to care about drives, filegroups or files.
I just want to restore all the tables in one place (in one database) so I can see the data.
Is there a way to do this easily?