To restore MS AG database by EMC NW NMM

Following last article, how to restore MS AG database , that is in the following:

You see ? From EMC NW console, we can see backup status

FULL BACKUP

Incr backup (TLOG backup)

AG different setting:

What interest thing is you see the different choose to make different behavour.

If we choose N4 backup source, we can see all database

If we choose N5 backup source, we have to select different group by different time.

Or

Let us pick one database for an example

Then all finished, we can see the result.

Here is restore log by EMC NW NMM

Recovering files of client 'LCHDCLSPNB51' from server 'LGCHEMNJ-BACKUP' to client 'ONLINETEST01'.

43708:(pid 5456):Start time: Tue Jan 03 13:17:54 2017

43621:(pid 5456):Computer Name: ONLINETEST01 User Name: administrator

NSR_CLIENT: xxxxxB51.ll.net

NSR_SERVER: BACKUP

37725:(pid 5456):Recovering database 'LGChem.N5.EIF.FORMATION' into 'LGChem.N5.EIF.FORMATION' ...

142468:(pid 5456):[3512]nsr/db_apps/bsmsql/rcstripes.c(222): Finding backup for saveset MSSQL:/LGChem.N5.EIF.FORMATION~1.

142468:(pid 5456):[3512]nsr/db_apps/bsmsql/rcstripes.c(222): Finding backup for saveset MSSQL:/LGChem.N5.EIF.FORMATION~2.

142468:(pid 5456):[3512]nsr/db_apps/bsmsql/rcstripes.c(222): Finding backup for saveset MSSQL:/LGChem.N5.EIF.FORMATION~3.

142468:(pid 5456):[3512]nsr/db_apps/bsmsql/rcstripes.c(222): Finding backup for saveset MSSQL:/LGChem.N5.EIF.FORMATION~4.

37839:(pid 5456):Warning: Only 1 tape sessions will be used to restore 4 stripes.

29317:(pid 5456):Data will be restored using SQL removable pipes.

4690:(pid 5456):RESTORE database [LGChem.N5.EIF.FORMATION] FROM virtual_device='Legato#c6be8dbb-2e4c-4a85-b7da-1ba4882213b7' WITH move

'LGChem.N5.EIF.FORMATION' to 'M:\DATA2\LGChem.N5.EIF.FORMATION_LGChem.N5.EIF.FORMATION_676.mdf', move 'LGChem.N5.EIF.FORMATION_log' to 'M:

\DATA2\LGChem.N5.EIF.FORMATION_LGChem.N5.EIF.FORMATION_log_676.ldf', replace, maxtransfersize = 4194304, norecovery

35866:(pid 5456):The restore of database 'LGChem.N5.EIF.FORMATION' completed successfully.

142468:(pid 5456):[3512]nsr/db_apps/bsmsql/rcstripes.c(222): Finding backup for saveset MSSQL:/LGChem.N5.EIF.FORMATION.

4690:(pid 5456):RESTORE log [LGChem.N5.EIF.FORMATION] FROM virtual_device='Legato#e32caf9a-7120-4309-8c9e-0e6777355f6f' WITH maxtransfersize = 4194304,

norecovery

35866:(pid 5456):The restore of database 'LGChem.N5.EIF.FORMATION' completed successfully.

142468:(pid 5456):[3512]nsr/db_apps/bsmsql/rcstripes.c(222): Finding backup for saveset MSSQL:/LGChem.N5.EIF.FORMATION.

4690:(pid 5456):RESTORE log [LGChem.N5.EIF.FORMATION] FROM virtual_device='Legato#c01585c8-5fc2-4076-abcc-ed54bd8daa5a' WITH maxtransfersize = 4194304,

norecovery

35866:(pid 5456):The restore of database 'LGChem.N5.EIF.FORMATION' completed successfully.

142468:(pid 5456):[3512]nsr/db_apps/bsmsql/rcstripes.c(222): Finding backup for saveset MSSQL:/LGChem.N5.EIF.FORMATION.

4690:(pid 5456):RESTORE log [LGChem.N5.EIF.FORMATION] FROM virtual_device='Legato#5133eafd-79a9-4662-afa8-1c799b21242e' WITH maxtransfersize = 4194304,

norecovery

35866:(pid 5456):The restore of database 'LGChem.N5.EIF.FORMATION' completed successfully.

142468:(pid 5456):[3512]nsr/db_apps/bsmsql/rcstripes.c(222): Finding backup for saveset MSSQL:/LGChem.N5.EIF.FORMATION.

4690:(pid 5456):RESTORE log [LGChem.N5.EIF.FORMATION] FROM virtual_device='Legato#578eb90f-63de-4cdc-bd24-b6249b8fe975' WITH maxtransfersize = 4194304,

norecovery

35866:(pid 5456):The restore of database 'LGChem.N5.EIF.FORMATION' completed successfully.

142468:(pid 5456):[3512]nsr/db_apps/bsmsql/rcstripes.c(222): Finding backup for saveset MSSQL:/LGChem.N5.EIF.FORMATION.

4690:(pid 5456):RESTORE log [LGChem.N5.EIF.FORMATION] FROM virtual_device='Legato#c4e8e33a-17a1-436f-9a14-2ce4a05dea3e' WITH maxtransfersize = 4194304,

norecovery

35866:(pid 5456):The restore of database 'LGChem.N5.EIF.FORMATION' completed successfully.

142468:(pid 5456):[3512]nsr/db_apps/bsmsql/rcstripes.c(222): Finding backup for saveset MSSQL:/LGChem.N5.EIF.FORMATION.

4690:(pid 5456):RESTORE log [LGChem.N5.EIF.FORMATION] FROM virtual_device='Legato#7ec9679d-303b-47ee-8390-7c8829501391' WITH maxtransfersize = 4194304,

norecovery

35866:(pid 5456):The restore of database 'LGChem.N5.EIF.FORMATION' completed successfully.

142468:(pid 5456):[3512]nsr/db_apps/bsmsql/rcstripes.c(222): Finding backup for saveset MSSQL:/LGChem.N5.EIF.FORMATION.

4690:(pid 5456):RESTORE log [LGChem.N5.EIF.FORMATION] FROM virtual_device='Legato#d3fd0e9f-febf-4ed0-9b06-202eac29d724' WITH maxtransfersize = 4194304,

norecovery

35866:(pid 5456):The restore of database 'LGChem.N5.EIF.FORMATION' completed successfully.

142468:(pid 5456):[3512]nsr/db_apps/bsmsql/rcstripes.c(222): Finding backup for saveset MSSQL:/LGChem.N5.EIF.FORMATION.

4690:(pid 5456):RESTORE log [LGChem.N5.EIF.FORMATION] FROM virtual_device='Legato#6b7874d9-e3b0-48e9-b1fc-853924ef5bfc' WITH maxtransfersize = 4194304

35866:(pid 5456):The restore of database 'LGChem.N5.EIF.FORMATION' completed successfully.

29310:(pid 5456):

Received 17 MB 9 item(s) from NSR server (size information for snapshot(s) is not available).

nsr/db_apps/bsmsql/rcovmain.cpp(442): Entering cleanUp().

nsr/db_apps/bsmsql/rcovmain.cpp(500): Exiting cleanUp().

43709:(pid 5456):Stop time: Tue Jan 03 13:25:31 2017

Restore completion time: Tue Jan 03 13:25:32 2017

Thanks,

Any question , please free to ask,