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: [EMAIL PROTECTED] Marc Layne <[EMAIL PROTECTED] To: [EMAIL PROTECTED] 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.