Re: [ADSM-L] MSSQL, restore all DBs in an instance
2016-03-17 14:45:08
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.
> >
>
|
|
|