Filegroup with SQL Server virtual server

What the best way to move a SQL Server 2000 virtual server with Austin_Sales
as the virtual server name and REPT as the name instance set but as a
non-filegroup. Create a new SQL Server 2000 virtual server with a named
instance get the data from Austin_Sales\REPT database into the new filegroup
database?
Thanks,
Restore will give you (essentially) a binary image of what is inside the
database. I.e., you cannot
change filegroup layout through backup/restore. You'd have to do that before
the backup or after the
restore...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Joe K." <JoeK@.discussions.microsoft.com> wrote in message
news:CFB09E6E-E210-4D53-B26E-98FFAC443E70@.microsoft.com...
I have a SQL Server 2000 virtual server with Austin_Sales as the virtual
server name and REPT as the name instance. This is Active\Active Cluster wit
h
Windows 2000 Advanced Server as the OS.
I have a new server and would like to have filegroups for the database.
Can I create filegroups on the new server and restore the backup from
Austin_Sales\REPT in the database with filegroups?
Please help me with this task.
Thanks,That depends on what goal you are after with file groups. What are you
trying to accomplish?
Sincerely,
Anthony Thomas
"Joe K." wrote:

> What the best way to move a SQL Server 2000 virtual server with Austin_Sal
es
> as the virtual server name and REPT as the name instance set but as a
> non-filegroup. Create a new SQL Server 2000 virtual server with a named
> instance get the data from Austin_Sales\REPT database into the new filegro
up
> database?
> Thanks,
>
> Restore will give you (essentially) a binary image of what is inside the
> database. I.e., you cannot
> change filegroup layout through backup/restore. You'd have to do that befo
re
> the backup or after the
> restore...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Joe K." <JoeK@.discussions.microsoft.com> wrote in message
> news:CFB09E6E-E210-4D53-B26E-98FFAC443E70@.microsoft.com...
> I have a SQL Server 2000 virtual server with Austin_Sales as the virtual
> server name and REPT as the name instance. This is Active\Active Cluster w
ith
> Windows 2000 Advanced Server as the OS.
> I have a new server and would like to have filegroups for the database.
> Can I create filegroups on the new server and restore the backup from
> Austin_Sales\REPT in the database with filegroups?
> Please help me with this task.
> Thanks,
>