Video Screencast Help

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