Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

SQL RESTORE

Created: 08 Aug 2012 • Updated: 09 Aug 2012 | 2 comments
This issue has been solved. See solution.

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

Comments 2 CommentsJump to latest comment

Marianne's picture

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)

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links