backup restore database into different filegroup arrangement

Hi,
Is there a way to restore the backup files of a database
which has only one file and one filegroup (primay) into a
database which has multiple files and filegroups? and can
the reverse to be done (multiple files into one file)?
e.g.:
db1, db1_data on primary
restore db1 backup file into
db2 (db2_data1, primary
db2_data2, secondary)
Is there a direct way to use 'backup-restore' method?
We basically want the same data but we want to re-arrange
the file management of the database.
many thanks!
JJ
I'm afraid not. A backup is essentially an image of the database, which is why you need the same amount of
files with each at least the same size and logical filename as when the backup was performed.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in message
news:1569601c415fc$b972b1e0$a401280a@.phx.gbl...
> Hi,
> Is there a way to restore the backup files of a database
> which has only one file and one filegroup (primay) into a
> database which has multiple files and filegroups? and can
> the reverse to be done (multiple files into one file)?
> e.g.:
> db1, db1_data on primary
> restore db1 backup file into
> db2 (db2_data1, primary
> db2_data2, secondary)
> Is there a direct way to use 'backup-restore' method?
> We basically want the same data but we want to re-arrange
> the file management of the database.
> many thanks!
> JJ
>
>
>
|||thanks for the feedback, Tibor.
I will try it out, but I'm pretty sure that it can't be
done like you said. :-)
JJ
>--Original Message--
>I'm afraid not. A backup is essentially an image of the
database, which is why you need the same amount of
>files with each at least the same size and logical
filename as when the backup was performed.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>
>"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in
message
>news:1569601c415fc$b972b1e0$a401280a@.phx.gbl...
a
can
arrange
>
>.
>