This is documented in admin guide - see nsrsqlrc command usage in the document. I'm also sure that if you search KB for nsrsqlrc you will find examples.
Yes I went through the KB. But I would like to perform it from backup server. Since, Getting error frequently like unable to browse or browse takes along time for a 60GB data (min. 4 hrs).
Is it possible to include SSID to do the restore instead of time option -t xxxxxxxxxxxxx
With CLI it is much faster - that's why I use it too. You can also run it in GUI with time range which makes browsing much faster. There is no SSID option.
Along with NMM, you will get NMSQL GUI if you backup your SQL databases using VDI method. Please use that GUI and try to change the browse time. It's very easy.
am facing issue to choose the browse time. It take long hrs to browse a file for particular date. Actually, its a known bug in NMM 3 and above versions. If we use cli its far better than GUI. Here my question is where to change the time range? Is it in registry level or application level to reduce the browsing time.
You can use the "-t" option to choose a particular date to restore from, as described in the documentation:
-t: Recovers the SQL Server data at a specified date. If the date of a backup version is before or is equivalent to the specified date, the backup version is recovered. Follow the nsr_getdate command syntax guidelines when formatting the date. To avoid adversely affecting the database, do not use the -t option if restoring a file or filegroup.
For more information about nsrsqlrc.exe command please refer to the documentation.
Yes, I tried with the following cmd.. nsrsqlrc -s "NetworkerServer" -c "NetworkerClient"-d "MSSQL:CopyOfABC" -C " 'ABC_Data='DestinationLocation\CopyOfABC.MDF', 'ABC_Log=DestinationLocation\CopyOfABC.LDF' " -t "nsavetime" "MSSQL:ABC"
Browse taken along time around 3 hrs for 67GB data and after 1 hr I got the below error "Missing relocation for logical file %s. 1 23 10" , " No logical file named %s in original database 1 23 15" & "Database file relocation list error. Actual file list is: 0"
The name to relocate might be something different - I also learned that harder way You can verify that with nsrinfo as actual name is there. As for -t, I hope you use actual nsavetime, but -t part we were discussing before was for nwmssql.exe. You state you used nsrsqlrc which should not browse as -t is given. However, there was a bug (and patch) for certain NMM releases - which build do you use?
prashanna
48 Posts
0
March 10th, 2015 23:00
can anyone suggest a proper way to do this restore.
ble1
4 Operator
•
14.4K Posts
0
March 11th, 2015 03:00
This is documented in admin guide - see nsrsqlrc command usage in the document. I'm also sure that if you search KB for nsrsqlrc you will find examples.
prashanna
48 Posts
0
March 16th, 2015 09:00
Yes I went through the KB. But I would like to perform it from backup server. Since, Getting error frequently like unable to browse or browse takes along time for a 60GB data (min. 4 hrs).
Is it possible to include SSID to do the restore instead of time option -t xxxxxxxxxxxxx
ble1
4 Operator
•
14.4K Posts
1
March 16th, 2015 15:00
With CLI it is much faster - that's why I use it too. You can also run it in GUI with time range which makes browsing much faster. There is no SSID option.
prashanna
48 Posts
1
March 19th, 2015 08:00
How to change the time range and where to change the time range in NMM application for browsing in GUI.
Raja_Bala
37 Posts
0
March 19th, 2015 08:00
Along with NMM, you will get NMSQL GUI if you backup your SQL databases using VDI method. Please use that GUI and try to change the browse time. It's very easy.
prashanna
48 Posts
0
March 19th, 2015 21:00
am facing issue to choose the browse time. It take long hrs to browse a file for particular date. Actually, its a known bug in NMM 3 and above versions. If we use cli its far better than GUI. Here my question is where to change the time range? Is it in registry level or application level to reduce the browsing time.
CarlosRojas
1.7K Posts
0
March 23rd, 2015 00:00
Hi Prashanna,
You can use the "-t" option to choose a particular date to restore from, as described in the documentation:
-t: Recovers the SQL Server data at a specified date. If the date of a backup version is before or is equivalent to the specified date, the backup version is recovered. Follow the nsr_getdate command syntax guidelines when formatting the date. To avoid adversely affecting the database, do not use the -t option if restoring a file or filegroup.
For more information about nsrsqlrc.exe command please refer to the documentation.
Thank you,
Carlos
prashanna
48 Posts
0
March 25th, 2015 11:00
Hi Carlos,
Yes, I tried with the following cmd.. nsrsqlrc -s "NetworkerServer" -c "NetworkerClient"-d "MSSQL:CopyOfABC" -C " 'ABC_Data='DestinationLocation\CopyOfABC.MDF', 'ABC_Log=DestinationLocation\CopyOfABC.LDF' " -t "nsavetime" "MSSQL:ABC"
Browse taken along time around 3 hrs for 67GB data and after 1 hr I got the below error "Missing relocation for logical file %s. 1 23 10" , " No logical file named %s in original database 1 23 15" & "Database file relocation list error. Actual file list is: 0"
Regards,
B.Prashanna
ble1
4 Operator
•
14.4K Posts
0
March 25th, 2015 13:00
The name to relocate might be something different - I also learned that harder way
You can verify that with nsrinfo as actual name is there. As for -t, I hope you use actual nsavetime, but -t part we were discussing before was for nwmssql.exe. You state you used nsrsqlrc which should not browse as -t is given. However, there was a bug (and patch) for certain NMM releases - which build do you use?
prashanna
48 Posts
0
March 26th, 2015 06:00
Nw Server 8.1.1.9 Nw client 8.1.1.7 NMM 3.0.1
ble1
4 Operator
•
14.4K Posts
0
March 26th, 2015 08:00
What is the build number of NMM?