Hello all,
I have two SQL Servers both running Windows 2000, and using TDP for SQL
(version 5.1.5). Let's call the servers Server A and Server B. I have
backed up the Northwind database (just using Northwind as an example) on
Server A and need to restore it on Server B. I have copied the dsm.opt file
from Server A to Server B and have named it dsm_A.opt, and am using the
option /TSMOptFile=dsm_A.opt. No matter what I try to do, I get
authentication errors. I have tried both PasswordAccess=Generate and
PasswordAccess=Prompt. I have even gotten brave and renamed the
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\ADSM\CurrentVersion\BackupClient\Nodes\SQL-S
erverA key in the registry so that the password would get stored again.
Now, I'm new to TDP (we are just transitioning to it), so I'm guessing there
may be something simple that I am missing here. I already looked at
http://search.adsm.org for the string FromSQLServer, but didn't see anything
there to help me. Can you help me out?
Here is a typical command I am trying to run (names have been changed to
protect the vulnerable ^H^H^H^H^H^H^H^H^H^H innocent):
tdpsqlc restore Northwind /FROMSQLServer=ServerA /SQLServer=ServerB
/MountWait=Yes /TSMOptFile=dsm_A.opt
Here is the contents of dsm_A.opt - again, names have been changed to
protect the innocent. By the way, if anyone replies via email, I will send
you whatever original configuration files. I just don't want to post them
where they will be accessible on the internet.
<snip>
*======================================================================*
* *
* IBM Tivoli Storage Manager for Databases *
* *
* Data Protection for Microsoft SQL Server *
* *
* Sample Options File *
* *
*======================================================================*
NODename SQL-SERVERA.ABC.MYSCHOOL.EDU
CLUSTERnode NO
*PASSWORDAccess Prompted
*PASSWORDAccess Prompt
PASSWORDAccess Generate
*======================================================================*
* TCP/IP Communication Options *
*======================================================================*
COMMMethod TCPip
TCPServeraddress xyz.abc.myschool.edu
TCPPort 1500
TCPWindowsize 63
TCPBuffSize 32
*======================================================================*
* Named Pipes Communication Options *
*======================================================================*
*COMMMethod NAMEdpipe
*NAMedpipename \\.\pipe\tsmpipe
*======================================================================*
* - Compression Options *
* *
* Use the "COMPRESSION" option to compress the data before sending *
* it to the IBM Tivoli Storage Manager server. Use the *
* "COMPRESSALWAYS" option to specify whether to continue compressing *
* the data if it grows during compression. *
* *
*======================================================================*
COMPRESSIon NO
*COMPRESSAlways NO
*======================================================================*
* *
* - Scheduling Options *
* *
* The default scheduling mode is the client polling method. *
* To use server prompted scheduling, you must be sure to use a tcp *
* client port different than the one used by the regular backup *
* client. *
* *
*======================================================================*
SCHEDMODE Polling
*SCHEDLOGRetention 14
*SCHEDMODE Prompted
*TCPCLIENTADDRESS yy.yy.yy.yy
*TCPCLIENTPORT 1502
*======================================================================*
* Include/Exclude Processing *
* *
* For a more complete description of include/exclude processing see *
* the Data Protection for Microsoft SQL Server Installation and *
* User's Guide (Chapter 3 and Appendix B) *
*======================================================================*
*======================================================================*
* The following include statements assign all meta objects to *
* management class SqlDbMetaMgmtClass and all data objects to *
* SqlDbDataMgmtClass *
*======================================================================*
*INCLUDE "\...\meta\...\*" SqlDbMetaMgmtClass
*INCLUDE "\...\data\...\*" SqlDbDataMgmtClass
INCLUDE "\...\meta\...\*" META-60
INCLUDE "\...\data\...\*" DATA-60
*======================================================================*
* The following include statements assign all log meta objects to *
* management class SqlLogMetaMgmtClass and all log data objects to *
* SqlLogDataMgmtClass *
*======================================================================*
*INCLUDE "\...\meta\...\log*" SqlLogMetaMgmtClass
*INCLUDE "\...\data\...\log*" SqlLogDataMgmtClass
*======================================================================*
* The following exclude statements exclude all log backups for *
* databases master and msdb *
*======================================================================*
*EXCLUDE "\...\master\...\log*"
*EXCLUDE "\...\msdb\...\log*"
*======================================================================*
* The following exclude statement excludes the "db1" database *
* from being compressed (if compression is enabled for backups.) *
*======================================================================*
*EXCLUDE.COMPRESSION "\...\db1\...\*"
</snip>
Let me know if you need to see any other files.
Thanks a million,
Chris
___________________________________________
Chris Leonard, University of Iowa ITS DBA
300 USB / 319-384-0801
Pound! Bang! Bin! Bash!
Is this a shell script, or a Batman comic?
|
