Hi Moses,
Yes, this is a supported and documented feature...
I'm looking at the readme for 'IBM Tivoli Storage Manager for Databases
Data Protection for Microsoft SQL Server' (or TDPS as we call it around
here!) version 5.2.1, and one of the sections is entitled "Alternate
Server Restore Procedure". It gives you a few knowledge base references,
and points you to the following:
http://www.ibm.com/Search?v=11&lang=en&cc=us&q=alternate+sql+restore
Good luck,
David McClelland
Tivoli Storage Manager Certified Consultant
Management Systems Capabilities Group
Shared Infrastructure Development
Reuters
85 Fleet Street
London EC4P 4AJ
REUTERS.KNOW.NOW.
www.reuters.com
www.reuters.com/customers
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Moses Show
Sent: 18 August 2004 17:04
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Restoring an SQL database
Hi chaps,
Can anybody enlighten me as to whether it is possible using TDP
for SQL to restore a a backup taken on one SQL server to a different SQL
server. I have been asked to perform the said task, but if it is not a
workable practice then I would need to find a way around this. Any help
would be gratefully received.
========================================================================
======
This communication, together with any attachments hereto or links
contained herein, is for the sole use of the intended recipient(s) and
may contain information that is confidential or legally protected. If
you are not the intended recipient, you are hereby notified that any
review, disclosure, copying, dissemination, distribution or use of this
communication is STRICTLY PROHIBITED. If you have received this
communication in error, please notify the sender immediately by return
e-mail message and delete the original and all copies of the
communication, along with any attachments hereto or links herein, from
your system.
========================================================================
======
The St. Paul Travelers e-mail system made this annotation on 08/18/2004,
11:59:40 AM.
-----------------------------------------------------------------
Visit our Internet site at http://www.reuters.com
Get closer to the financial markets with Reuters Messaging - for more
information and to register, visit http://www.reuters.com/messaging
Any views expressed in this message are those of the individual
sender, except where the sender specifically states them to be
the views of Reuters Ltd.
|
