SQLTeam.com | Weblogs | Forums

Restore a backup from primary filegroup into the secondary filegroup


#1

Hi,

We have to migrate a SQL-2008 DB to SQL 2014. All 300 tables are hosted in primary filegroup.
The new server has a secondary filegroup with multiple files - laying on a fusion-IO.
Can i restore a backup from old server to the new server into the secondary filegroup? (Upgrade advisor is done)
Or, have i to move the tables manually from primary to secondary (over clustered index).
Or, create a empty Target-DB with (Insert into new table - Select from old table) for all 300 tables :frowning: ?
What is the most effective way to do this?
Or are there helping tools to do a lot of this work?

Regards
Nicole


#2

AFAIK, it's not possible to restore to a different filegroup. You have to move it to a different filegroup after restoring it.