UNSOLVED
mminfo: how to display database backup time?
Hello,
[Context]
Networker 8.2.4: I’m trying to restore our database backups using the command “nsrsqlrc”.
[Status]
It’s working but now I’m trying to figure out what the best way to get the “-t” information, for instance “-t "Mon Sep 19 13:40:48 2016"”
I’ve got this line that gives me some information regarding the backup time, but the field “name” gives the instance name, not the database name, so it’s useless.
mminfo -q "client=vmsqlpr02,savetime>=last day" -r "name,level,savetime(22),nsavetime" -ot
Dirty fix: from the client, I can look in nsr\applogs\nsrsqlsv.raw and get the time of the last backup, something like
37996 31.08.2016 13:06:49 0 0 0 4044 6464 0 mysqlsvr.domain.com (pid6464) NSR info The backup of MyDB has completed successfully
Then I can use the backup time information for the “-t”
[Questions]
How can I get the backup times for a given database, ie the equivalent of what you get from “Networker User for SQL Server” when browsing from a different time?
Thanks in advance for any information.
2354
0
Posted September 20th, 2016 05:00
Thanks Hrvoje Crvelin for you reply.
Regarding nsrinfo syntax, how can I get the dates with the correct format?
mminfo? If so, which syntax?
Right now I'm using something like
nsrinfo -n mssql mysqlserver | findstr "mydbname" | findstr "14.09.2016"
Is there a more clever way of doing it?
Thanks.
2354
0
Posted September 21st, 2016 04:00
I personally never had to do it so I never bang my head around it, but I guess I would do the same as you and select time which fits me.
2354
0
Posted September 21st, 2016 04:00
Never had to do it ... until the GUI became so slow !!
It takes forever to browse the different backup versions ...
It's way faster to use nsrsqlrc instead.
And nsrinfo just gave me what I needed to make it work, perfect
1354
0
Posted September 21st, 2016 05:00
Hi,
You can check sscreate for exact backup time:
mminfo -q "client=vmsqlpr02,savetime>=last day" -r "client,name,ssid,volume,totalsize,sscreate(17),sscomp(17),group,level,ssbrowse,ssretent,nsavetime" -ot
2354
0
Posted September 21st, 2016 06:00
GUI is slow as it loads all records... I believe recent version of module have switch where you can limit the browsing range which should make browsing via GUI much faster.
2354
0
Posted September 21st, 2016 07:00
Do you know if "Networker User for SQL Server" 8.2.2.0.926 supports it?
Can't find such filter anywhere
2354
0
Posted September 21st, 2016 11:00
It seems browsing issue was addressed in 1st patch after your build (you can find binaries at ftp://ftp.legato.com/pub/NetWorker/NMM/Cumulative_Hotfixes/
2354
0
Posted September 21st, 2016 23:00
Thanks for the link, didn't think of checking there !!
We've got Networker Server 8.2.2.4.
Should I install this one ?
ftp://ftp.legato.com/pub/NetWorker/NMM/Cumulative_Hotfixes/8.2.2/8.2.2.4/nmm822_win_x64.zip
Or use the latest one?
ftp://ftp.legato.com/pub/NetWorker/NMM/Cumulative_Hotfixes/8.2.2/8.2.2.6/nmm822_win_x64.zip ??
Thanks for your help.
1201
0
Posted September 22nd, 2016 07:00
I would just go for latest one.
ble1
6 Operator
•
14354 Posts
•
56186 Points
2354
1
Posted September 19th, 2016 13:00
You will see it in MSSQL Studio, but from backup server you can run nsrinfo -n mssql to see it as well. Example of output:
MSSQL:/, date=1473866593 Wed 14 Sep 2016 05:23:13 PM CEST
MSSQL:/msdb, date=1473866588 Wed 14 Sep 2016 05:23:08 PM CEST
MSSQL:/msdb%/files.1473866588.1473866605, date=1473866588 Wed 14 Sep 2016 05:23:08 PM CEST
MSSQL:/model, date=1473866585 Wed 14 Sep 2016 05:23:05 PM CEST
MSSQL:/model%/files.1473866585.1473866600, date=1473866585 Wed 14 Sep 2016 05:23:05 PM CEST
MSSQL:/master, date=1473866583 Wed 14 Sep 2016 05:23:03 PM CEST
MSSQL:/master./PRIMARY, date=1473866583 Wed 14 Sep 2016 05:23:03 PM CEST
MSSQL:/master./PRIMARY./master, date=1473866583 Wed 14 Sep 2016 05:23:03 PM CEST
MSSQL:/master./, date=1473866583 Wed 14 Sep 2016 05:23:03 PM CEST
MSSQL:/master./PRIMARY./, date=1473866583 Wed 14 Sep 2016 05:23:03 PM CEST