Geoff
Not sure if you have had any success with this - i only read you post
this morning.
I've been through this procedure several times - this is what i have
done:
RESTORE TO ANOTHER SERVER - example SERVER1 to SERVER2
I can restore server MYSQL to server SERVER2.
Logon to SERVER2 server.
Opt file: (typically) c:\program files\tivoli\tsm\tdpsql\dsm.opt
Change the nodename parameter in DSM.OPT to SERVER1. I also need the
TDPSQL.CFG file to show the correct nodename.
Now change file c:\program files\tivoli\tsm\tdpsql\tdpsql.cfg
Exact procedure for TDPSQL.CFG is
Leave SQLSERVER blank.
This parameter specifies the SQL server that TDP for SQL logs onto. For
restore operations, this is the SQL server that backup objects are
restored to. However, if the backup objects were created from a
different SQL server, you must use the /FROMSQLSERVER parameter (next)
Change FROMSQLSERVER to SERVER1
For restore operations, this parameter specifies the SQL server from
which the objects were backed up from. It is only used when the name of
the SQL server to restore to is different from the SQL server that
backed up the objects.
When I start the GUI, it DEFAULTS to the BACKUP DATABASES tab and when
expanded, will show the name of the LOCAL SERVER, which of course I
don't want.
Click on the RESTORE DATABASES tab and expand the tree from there. I
will then see the SERVER FROM WHICH I WISH TO RESTORE.
If you want to restore a database that is not the latest backup, then
click on ACTIVE and INACTIVE Files button.
Click the database you wish to restore and the REPLACE button, assuming
the database already exists
Click RESTORE
Note:
Restoral times: Before 2005: The larger the database being restored, the
more time is required, as the DB file "container" is recreated on disk,
with pre-formatting, before its contents can be restored. For example,
you restore a 200gb database, which may take several hours. The TDP
waits around for the MSSQL work to complete before the TDP can proceed.
(Boosting the TSM COMMTimeout value is advised.) This should improve in
SQL Server 2005, where SQL Server must still allocate the file space
before doing a database restore, but the time-consuming initialization
of database pages is no longer required.
When the restore is complete, don't forget to change the DSM.OPT and
TDPSQL.CFG back to what they were.
Hope this helps
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Gill, Geoffrey L.
Sent: 08 March 2008 03:09
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] sql server restore to different server
Importance: High
No replies on the first post so let's try this. We have NT4 back up on a
box running sqlserver but the guy did not name the sql server the name
it was backing up under. My guess is this is why we are seeing nothing
looking to restore the db's. Having never done this, how can I restore a
database backed up on a sql server, call it server 1, to server2? So far
my attempts at trying to use the tdpsql.cfg for this, which is where the
from and to options are, have not worked.
Thanks for any quick and easy help anyone can supply. In the mean time I
also asked the person who made this to change the name of the sqlserver
to the old name it was backed up under to hopefully solve the problem
quicker.
Geoff Gill
TSM Administrator
PeopleSoft Sr. Systems Administrator
SAIC M/S-G1b
(858)826-4062
Email: [EMAIL PROTECTED]
------------------------------------------------------------------------
--------------
Email scanned for viruses and spam by the Woolworths
anti-virus systems.
If you believe this email is spam, please forward to
[EMAIL PROTECTED]
****************************************************************************
Woolworths plc
Registered Office: Woolworth House, 242/246 Marylebone Road, London NW1 6JL
Registered in England, Number 104206
This e-mail is only intended for the person(s) to whom it is addressed and
may contain confidential information. Unless stated to the contrary, any
opinions or comments are personal to the writer and do not represent the
official view of the company. If you have received this e-mail in error,
please notify us immediately by reply e-mail and then delete this message
from your system. Please do not copy it or use it for any purposes, or
disclose its contents to any other person. Thank you for your co-operation.
****************************************************************************
------------------------------------------------------------------------------------
Email scanned for viruses and unwanted content by emailsystems
Information regarding this service can be found at www.emailsystems.com
