dreamz
ADSM.ORG Member
- Joined
- Dec 30, 2008
- Messages
- 162
- Reaction score
- 1
- Points
- 0
Hi...
This is very urgent for me to complete this task. I'm supposed to restore a sql database to another server. I copied the dsm.opt file from the source server to destination and opened sql client gui, selected wait for tape mounts for restore and file information. I DID not check Replace.
Now when I selected the db i want to restore and say RESTORE it just starting restoring without asking me an option to restore where. I'm afraid it would overwrite the existing database entries.
IBM documentation says like this to select an alternate server :
Can some one please guide me how to restore the tdp databases to alternate server. It's very urgent and I'm helpless. Any quick help is greatly appreciated.
Thank you so much!!
This is very urgent for me to complete this task. I'm supposed to restore a sql database to another server. I copied the dsm.opt file from the source server to destination and opened sql client gui, selected wait for tape mounts for restore and file information. I DID not check Replace.
Now when I selected the db i want to restore and say RESTORE it just starting restoring without asking me an option to restore where. I'm afraid it would overwrite the existing database entries.
IBM documentation says like this to select an alternate server :
- Right mouse-click on the selected database and use the Relocate |Settings dialog to specify a new destination location in which to |restore the database. |
Can some one please guide me how to restore the tdp databases to alternate server. It's very urgent and I'm helpless. Any quick help is greatly appreciated.
Thank you so much!!