Partial restores are only available in SQL server 2000. It is only possible
to do partial restores on full database backup objects.
When performing a partial restore, the primary file group must always be
restored, together with the other files you specify.
When doing a partial restore on a new server, you must do this from the TDP
for SQL CLI, because the relocation option
is not valid with partial restore using TDP for SQL GUI.

>From the SQL for TDP CLI, it is possible to restore with the parameters
/partial /groups /relocate /to -- the database does not need to be
present."


Clarence Beukes
 Advisory IT Specialist - Tivoli Certified Consultant
 Geomar SSO Mid Range and Application Support Discipline
 Location:  IBM Park Sandton, IA2G
 Tel: +27 (0) 11 302-6622   Cell: +27 (0) 82 573 5665
 E-mail: clarence AT za.ibm DOT com




                      Marc Layne
                      <[email protected]        To:       ADSM-L AT VM.MARIST 
DOT EDU
                      OM>                      cc:
                      Sent by: "ADSM:          Subject:  Urgent: Relocating 
Filegroupsfrom TDP for SQL into another databse on
                      Dist Stor                 the same machine
                      Manager"
                      <[email protected]
                      .EDU>


                      17/12/02 11:41 AM
                      Please respond to
                      "ADSM: Dist Stor
                      Manager"





Hi All
We wish to restore indiviudual filegroups from TDP for SQL from one
database and relocate it into another one.

Our environment:
Win2k TSM server
TSM 5.1.5.3 server
TDP for SQL 2.2.1.0
MSSQL 2000 service pack 2

We are able to restore SQL files/groups to the same
location via the gui but the option is not available
to restore to a different location on the same server.

For this we have to use the command line tdpsqlc. With
the testing we have done we are unable to relocate the
group to a different database. The manual provides no
useable examples.

ps We have the latest patches installed.

Any help would be appreciated.

Thanks
Mike

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com


DISCLAIMER:
This message may contain information which is confidential, private or
privileged in nature. If you are not the intended recipient, you may not
peruse, use, disseminate, distribute or copy this message or file which is
attached to this message. If you have received this message in error,
please notify the sender immediately by e-mail, facsimile or telephone and
thereafter return and/or destroy the original message.

Any views of this communication are those of the sender except where the
sender specifically states them to be those of Faritec (Holdings)  Limited
(Faritec) and/or  any of its subsidiaries including (but not limited to)
Faritec Enterprise Solutions (Proprietary) Limited, Faritec Strategic IT
Services (Proprietary) Limited, Faritec Contracting (Proprietary) Limited;
and/or ebis and any of its subsidiaries.

Please note that the recipient must scan this e-mail and any attached files
for viruses and the like. While we do everything possible to protect
information from viruses, Faritec accepts no liability of whatever nature
for any loss, liability, damage or expense resulting directly or indirectly
from the access and/or downloading of any files which are attached to this
e-mail message.