ADSM-L

Urgent: Relocating Filegroupsfrom TDP for SQL into another databse on the same machine

2002-12-17 04:39:52
Subject: Urgent: Relocating Filegroupsfrom TDP for SQL into another databse on the same machine
From: Marc Layne <mlayne AT FARITEC DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 17 Dec 2002 11:41:12 +0200
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.

<Prev in Thread] Current Thread [Next in Thread>
  • Urgent: Relocating Filegroupsfrom TDP for SQL into another databse on the same machine, Marc Layne <=