1

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?

asked Jan 3, 2019 at 20:47

2 Answers 2

2

No it is not possible to do what you are asking. SQL is backing up the current state of the database. What tables are in what filegroup is part of the database information. It is possible to restore the backup to a new database name. Once the data is on the new server you could research and create the file groups you want, make your changes, etc. Get everything you the way you want it. Back it up a final time and then restore it to the database name you want or you can simply rename the database. Depending on the size it might be faster to restore it.

answered Jan 3, 2019 at 21:34
0

It isn't possible to do like that. need to do data migration DB01 to DB02.

answered Jan 3, 2019 at 20:55
0

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.