Thanks Del, I am trying to help our SQL guys doing the restore more efficiently. Will this command by default roll the databases forward to the latest possible time? Ie. the latest logbackup after last full? (Legacy backup).
Regards, Hans chr. On Thu, Mar 17, 2016 at 7:22 PM, Del Hoobler <hoob...@us.ibm.com> wrote: > 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" <ADSM-L@VM.MARIST.EDU> wrote on 03/16/2016 > 11:18:47 AM: > > > From: Hans Christian Riksheim <bull...@gmail.com> > > To: ADSM-L@VM.MARIST.EDU > > Date: 03/16/2016 11:19 AM > > Subject: MSSQL, restore all DBs in an instance > > Sent by: "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> > > > > 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. > > >
