What version of SQL? -------------------------------------- Bruce Kamp Midrange Systems Analyst II Memorial Healthcare System E: [EMAIL PROTECTED] P: (954) 987-2020 x4597 F: (954) 985-1404 ---------------------------------------
-----Original Message----- From: Bruce Lowrie [mailto:b.e.lowrie@;DOWCORNING.COM] Sent: Thursday, November 14, 2002 10:18 AM To: [EMAIL PROTECTED] Subject: Restore from one server to another using TDP 2.2.1 Can someone describe the exact procedure to restore a database backup from one server to another. This used to be quite straight forward with TDP 1.1.2 but does not work according to the directions with both the GUI and the command line. With the GUI, setting the 'from server' parameter in the configurations settings would imply that the GUI will query the TSM server for the backups from that server, it seems to have no affect whatsoever. With the command line again setting the FromSQLServer parm does nothing but return an error that no backups can be found for the server name 'SQL Servername'\meta\0000. Also it would seem to me that you would have to authenticate to TSM for both nodes, it's no apparent where you would provide the password for the from server. Regards, Tony Tony Lewis - Dow Corning Corp. BPIT C/S Application Services (Database Management) Phone (989) 496-1771 Mail WW2481 * E-Mail: [EMAIL PROTECTED] ________________________________________________________________________ This email has been scanned for all viruses by the MessageLabs SkyScan service. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.messagelabs.com ________________________________________________________________________