cancel
Showing results for 
Search instead for 
Did you mean: 

SQL RESTORE

NIKHIL234656595
Level 6

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

1 ACCEPTED SOLUTION

Accepted Solutions

rookie11
Moderator
Moderator
   VIP   
2 REPLIES 2

Marianne
Level 6
Partner    VIP    Accredited Certified

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)

rookie11
Moderator
Moderator
   VIP   

http://www.symantec.com/business/support/index?page=content&id=TECH35995  try this easy to understand .its a technote to do SQL restore