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:[EMAIL PROTECTED] On Behalf Of Moses Show Sent: 18 August 2004 17:04 To: [EMAIL PROTECTED] 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.
