Hi Hans Chr.

No. That will just restore the full backups.
You didn't mention that you had logs. :-)
(The devil is always in the details.)

This could work:

   TDPSQLC RESTORE * FULL /RECOVERY=NO

   TDPSQLC RESTORE * LOG=*

but I am not sure so you should test it,
or possibly open a PMR if you can't get it figured out.


Del

----------------------------------------------------


"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 03/17/2016 
02:43:44 PM:

> From: Hans Christian Riksheim <bullhcr AT GMAIL DOT COM>
> To: ADSM-L AT VM.MARIST DOT EDU
> Date: 03/17/2016 02:44 PM
> Subject: Re: MSSQL, restore all DBs in an instance
> Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> 
> 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 <hoobler AT us.ibm DOT 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 AT VM.MARIST DOT EDU> wrote on 03/16/2016
> > 11:18:47 AM:
> >
> > > From: Hans Christian Riksheim <bullhcr AT GMAIL DOT COM>
> > > To: ADSM-L AT VM.MARIST DOT EDU
> > > Date: 03/16/2016 11:19 AM
> > > Subject: MSSQL, restore all DBs in an instance
> > > Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT 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.
> > >
> >
>