08-08-2012 06:05 AM
Hi All,
What are the steps to do a Sql restore on a different server.
eg:source server:WIN23
destination server:WIN26
Master server :LX345
Sql database name:PQSYSTEM
Please provide the steps for this
Solved! Go to Solution.
08-09-2012 07:44 AM
http://www.symantec.com/business/support/index?page=content&id=TECH35995 try this easy to understand .its a technote to do SQL restore
08-08-2012 06:36 AM
Please follow steps in NBU for Microsoft SQL Server Admin Guide .
Look for topic called: Redirecting a restore to a different host.
Step 1 is done on master server. Creating No.Restrictions file is the easiest.
Step 2 onwards is done on Destination Client (WIN26).
Also read this section in the same manual: Minimizing timeout failures on large database restores.
Be sure to create log folders before you start. This is the only way to troubleshoot failures:
On master: bprd (NBU needs to be restarted to enable bprd logging)
On media server: bpbrm and bptm (no restart needed)
On destination client: (bpcd and dbclient)
08-09-2012 07:44 AM
http://www.symantec.com/business/support/index?page=content&id=TECH35995 try this easy to understand .its a technote to do SQL restore