JonRoenick
ADSM.ORG Member
I'm very new to the TSM software so bare with me a bit.
I have two SQL2000 servers that are both webservers with 1 being the "backup." If the primary one, called "Portal" died, how can i restore its database(s) to the backup server called "RPortal"? Ultimately what I would like to do is use TDPSQLC and write a scheduled task that does this once a week just in case. Or am i basically down until i reload another server and name it Portal then restore the DBs?
So far i tried this command on RPortal using Northwind as a test:
It gives me "ACO0261I There are no backups for the server named SQL-CHCPORTAL\meta\0000". I'm not sure where or what the \meta\0000 part means.
I was thinking that maybe i would have to create a different dsm.opt file that mimics RPortal and call it dsm2.opt, but that didn't help either. Now i'm out of ideas.
I have two SQL2000 servers that are both webservers with 1 being the "backup." If the primary one, called "Portal" died, how can i restore its database(s) to the backup server called "RPortal"? Ultimately what I would like to do is use TDPSQLC and write a scheduled task that does this once a week just in case. Or am i basically down until i reload another server and name it Portal then restore the DBs?
So far i tried this command on RPortal using Northwind as a test:
Code:
tdpsqlc restore Northwind full /tsmoptfile="C:\Progra~1\tivoli\tsm\tdpsql\dsm.opt" /fromsql=SQL-Portal
I was thinking that maybe i would have to create a different dsm.opt file that mimics RPortal and call it dsm2.opt, but that didn't help either. Now i'm out of ideas.