Restore Problem

Hi Guys,
I'm having a problem with a restore. Recently a new image column was added
to our database, my request was to place the column in it's own filegroup, I
had planned to do a full restore after the new filegroup was added, but due
to a lack of a change control process the column was added at the weekend
while I was away and no full back up was done. I'm now in a situation where
I have a full backup containing 1 filegroup and several differential and
transactional backups since with 2 filegroups. I've now had a request to
restore an old copy of the database for test purposes but I'm totally unsure
how to restore it... ...for ease I've been using EM as we have numerous
transactional backups in the bak file... ... restoring the full backup and
latest differential results in an error complaining the new filegroup isn't
in the database... ...is the error due to me selecting to restore both at th
e
same time through EM?... ...Would the database be consistant if I do a full
restore, add the new filegroup, then restore the differential?
Any advice would be very gratefully recieved.
Thanks in advance
BenI got around it using TSQL employing the WITH MOVE operation in the RESTORE
command.
"BenUK" wrote:

> Hi Guys,
> I'm having a problem with a restore. Recently a new image column was adde
d
> to our database, my request was to place the column in it's own filegroup,
I
> had planned to do a full restore after the new filegroup was added, but du
e
> to a lack of a change control process the column was added at the weekend
> while I was away and no full back up was done. I'm now in a situation whe
re
> I have a full backup containing 1 filegroup and several differential and
> transactional backups since with 2 filegroups. I've now had a request to
> restore an old copy of the database for test purposes but I'm totally unsu
re
> how to restore it... ...for ease I've been using EM as we have numerous
> transactional backups in the bak file... ... restoring the full backup an
d
> latest differential results in an error complaining the new filegroup isn'
t
> in the database... ...is the error due to me selecting to restore both at
the
> same time through EM?... ...Would the database be consistant if I do a ful
l
> restore, add the new filegroup, then restore the differential?
> Any advice would be very gratefully recieved.
> Thanks in advance
> Ben