SQL RESTORE

Created: 08 Aug 2012 | Updated: 09 Aug 2012 | 2 comments

NIKHIL2346565959

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

Discussion Filed Under:

Comments 2 Comments • Jump to latest comment

Marianne van den Berg Trusted Advisor Partner Accredited Certified

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

rookie11

SOLUTION