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" <[email protected]> wrote on 03/17/2016 02:43:44 PM: > From: Hans Christian Riksheim <[email protected]> > To: [email protected] > Date: 03/17/2016 02:44 PM > Subject: Re: MSSQL, restore all DBs in an instance > Sent by: "ADSM: Dist Stor Manager" <[email protected]> > > 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 <[email protected]> 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" <[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. > > > > > >
