March 13, 2007 at 7:36 am
Hello,
I have a database divided into some filegroups (eg FG1, FG2 and FG3).
I woluld like to copy to another database with same structure data in FG1 only.
Is it possible?
I have tried with RESTORE PARTIAL but it leaves objects belonging to FG2 e 3 offline, and so the database is not usable.
Is there a way?
March 14, 2007 at 2:04 am
I've wanted to achieve the same thing but unfortunately my research lef me to believe this was not possible. File and filegroup backup/restores seem very focused on recovery and not movement of data.
Please post back though if you find a way to do it.
sorry can't be more help
March 14, 2007 at 2:29 am
After lots of researches I found that:
Here it is written that is not possible to load data from a filegroup to a new empty database:
http://support.microsoft.com/?scid=kb%3Ben-us%3B281122&x=10&y=13
I 'll do use DTS o other methods to reach the same goal
thank
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply