10-06-2015 12:31 PM
SQL version: 2008 R2
NBU version: 7.6.0.3
I am task to restore sql db to an alternate location. I have created the script using usual MS SQL client gui & move template. ( I have done this countless time to restore alternate client request without issue)
But for some reason, i found that quite a lot of info/lines such as "MOVE, TO, source database path are all missing in the script.
Can any please advise why the above required lines are missing ? Thank you
Below is how the script appeared
#
# This is a template for the database MOVE command.
#
OPERATION RESTORE
OBJECTTYPE DATABASE
RESTORETYPE MOVE
#
# Replace the database name in the following line with the name of the database that you
# want to move to. Also remove the hash mark <#> which precedes the keyword <DATABASE>.
#
#DATABASE "ARSystem"
# The following image is type: Full
NBIMAGE "CRPPMS2-SQLD-N4.MSSQL7.CRPVSQLREMPRDS\REMPRD.db.ARSystem.~.7.001of001.20151003060014..C"
SQLHOST "CRPVMS2SQLCP2" ==================================> Destination
NBSERVER "VERITAS.NYCHHC.ORG"
BROWSECLIENT "CRPVSQLREMPRDs.central.nychhc.org" ===========> Source DB
MAXTRANSFERSIZE 6
BLOCKSIZE 7
RECOVEREDSTATE RECOVERED
NUMBUFS 2
ENDOPER TRUE
Solved! Go to Solution.
10-09-2015 09:47 AM
This issue has been resolved.
Method: 1
There's a bug in NBU version 7.6.0.3 assocated with Etrack3747591.The official fix is in Netbackup versions 7.6.1.2 & 7.7.1. For environment on 7.6.0.3, patch affect client to 7.6.0.4 & applied official EEBs from veritas. The EEBs can only be retrieve by opening a case with Symantec.
Method: 2
The alternate way to resolve this issue is by manually inserting missing keywords in the script.
10-06-2015 04:28 PM
# Replace the database name in the following line with the name of the database that you
# want to move to. Also remove the hash mark <#> which precedes the keyword <DATABASE>.
As stated above, at least, you have to set database name.
10-06-2015 08:58 PM
I hope you got my point here. Thank you
10-07-2015 05:50 AM
This appears to be an in-place restore of a full backup, this is the correct script for that type of restore.
Ensure sure you are selecting the move template option when generating the restore script.
10-07-2015 09:07 AM
Hi DG-2005, Yes am using a move template. but script won't come up as I stated above.
10-07-2015 11:03 AM
The issue is that, after the template is created using "move template" by default - the MOVE, TO parameters needs to be in the template which will be edited to point to new path. But in this case, this parameters are missing in the bash script.
This particular scenerio appears to be occuring for a specific sql instance not all my instance.
Am I by any chance missing something from SQL end?
10-09-2015 09:47 AM
This issue has been resolved.
Method: 1
There's a bug in NBU version 7.6.0.3 assocated with Etrack3747591.The official fix is in Netbackup versions 7.6.1.2 & 7.7.1. For environment on 7.6.0.3, patch affect client to 7.6.0.4 & applied official EEBs from veritas. The EEBs can only be retrieve by opening a case with Symantec.
Method: 2
The alternate way to resolve this issue is by manually inserting missing keywords in the script.