02-19-2014 04:20 AM
Hi Folks,
i have a problem in msql db that is running in serverA.there was some tables deleted. now we have a backup which was taken from Symantec Netback through backup script *.bch file. My query is i need to restore the dabatase to serverB and which was taken in tape, so could you please any one help how to restore the database and actual procedure to follow and what are the pre-requisited required in serverB. Thanks in advance.
Regards,
Veer
Solved! Go to Solution.
02-19-2014 09:58 PM
Apologies for only responding now - we seem to live in different parts of the world...
wr is correct - you need to use Move Template, and then edit the restore script to specify new name and new location.
The manual explains this in the sction that I pointed out yesterday under this topic:
02-19-2014 04:59 AM
Alternate Client/Redirected restore is covered in the NetBackup for Microsoft SQL Server Administrator's Guide
The restore must be initiated from the SQL server where you want to restore the databases to.
Before you do that, you need to authorize the alternate restore on the master server with No.Restrictions file or altnames entries for source and destination clients.
Step-by-step procedure under this topic in above manual:
Redirecting a SQL restore to a different host
Don't forget to create bpcd and dbclient log folders on destination client to troubleshoot in case the restore fails.
Also remember to increase Client Read Timeout as per recommendation in the same guide.
02-19-2014 05:10 AM
Ok. i will try and let you know the status ASAP. Thanks for your reply
02-19-2014 10:46 AM
Hi Marianne
i have save a script before restoration.
i renamed the database from "sm711_prd" to "sm711_prd_test", could you please check this and so that i can start the restoration... Thank you
Netbackup server --> INCHEAM-BKUP01
Original Server --> HSC0000133
Destination server --> hpsm-app
could you please brief on " RESTOREOPTION REPLACE"
===
OPERATION RESTORE
OBJECTTYPE DATABASE
DATABASE "sm711_prd_test"
# The following image is type: Full
NBIMAGE "HSC0000133.MSSQL7.HSC0000133.db.sm711_prd.~.7.001of001.20140214060603..C"
SQLHOST "hpsm-app"
NBSERVER "INCHEAM-BKUP01"
BROWSECLIENT "HSC0000133"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
RESTOREOPTION REPLACE
RECOVEREDSTATE NOTRECOVERED
NUMBUFS 2
ENDOPER TRUE
====
02-19-2014 01:16 PM
I just tried with above commads and got an error, i have attached error file.
here i have to restore in another server with d:\ drive location and database name also need to change. so whether i need to modify the script or need to create another method to restore. Thanks..
02-19-2014 01:50 PM
Please see Redirecting a database to a different location on a different host section in the Symantec NetBackup™ for Microsoft SQL Server Administrator's Guide to learn how to create a move template.
2/20/2014 1:17:38 AM - Info dbclient(pid=1828) DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <5133><[Microsoft][SQL Native Client][SQL Server]Directory lookup for the file "E:\SQLServer\MSSQL.1\MSSQL\DATA\sm711_prd.mdf" failed with the operating system error 21(The device is not ready.).>.
2/20/2014 1:17:39 AM - Info dbclient(pid=1828) DBMS MSG - SQL Message <3156><[Microsoft][SQL Native Client][SQL Server]File 'sm711_prd' cannot be restored to 'E:\SQLServer\MSSQL.1\MSSQL\DATA\sm711_prd.mdf'. Use WITH MOVE to identify a valid location for the file.>
02-19-2014 09:58 PM
Apologies for only responding now - we seem to live in different parts of the world...
wr is correct - you need to use Move Template, and then edit the restore script to specify new name and new location.
The manual explains this in the sction that I pointed out yesterday under this topic:
02-21-2014 02:30 AM
This is resolved by below script executed.
Script to move database to another server in another location
database name changed from sm711_prd to sm711_prd_restore
=====
02-21-2014 02:39 AM
Great stuff!
If you need to do this regularly, you may want to bookmark this TN:
http://www.symantec.com/docs/TECH74475