Filegroup Question

I have a database with 2 filegroups one filgroup is small and the other
is very large. Is there a way to restore this database to another sever
and leave the large filegroup behind and not use it?
*** Sent via Developersdex http://www.examnotes.net ***You could do a partial restore, but then you wouldn't have access to the
data that was in that large filegroup.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
"Sean John" <sj@.aol.com> wrote in message
news:OdOwuNIHGHA.2064@.TK2MSFTNGP09.phx.gbl...
I have a database with 2 filegroups one filgroup is small and the other
is very large. Is there a way to restore this database to another sever
and leave the large filegroup behind and not use it?
*** Sent via Developersdex http://www.examnotes.net ***|||
Do you have any syntax on doing a partial restore? Would it be like the
following:
*** Sent via Developersdex http://www.examnotes.net ***|||Example: Piecemeal Restore of Database (Full Recovery Model)
<http://msdn2.microsoft.com/en-us/library/ms175541.aspx>
*mike hodgson*
http://sqlnerd.blogspot.com
Sean John wrote:

>Do you have any syntax on doing a partial restore? Would it be like the
>following:
>
>
>
>*** Sent via Developersdex http://www.examnotes.net ***
>