Hi Hans Chr. Did you try using the * (wildcard) character?
TDPSQLC RESTORE * FULL The User's Guide shows * as a valid "dbname": http://www.ibm.com/support/knowledgecenter/SSTFZR_7.1.4/db.sql/dps_ref_cmd_restoresyn.html Thank you, Del ---------------------------------------------------- "ADSM: Dist Stor Manager" <[email protected]> wrote on 03/16/2016 11:18:47 AM: > From: Hans Christian Riksheim <[email protected]> > To: [email protected] > Date: 03/16/2016 11:19 AM > Subject: MSSQL, restore all DBs in an instance > Sent by: "ADSM: Dist Stor Manager" <[email protected]> > > We are doing a DR test and will restore a full instance of MSSQL, almost a > hundred databases > > From the manual I am not sure if this is possible with a single command. > Anyone? > > Hans Chr. >
