Restore multi-filegroup database to a new location and use only one filegroup? (sql2008r2)
Posted on 2012-04-03
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?