MS SQL Restore MS SQL Database to alternate client (Include file system to alternate client)

** Myself
Environment

Testing Machine information for alternate client Server name :    TPC-BSR3AP81 IP:                    10.10.10.10 Subnet:             255.255.255.0 Default Gateway: 10.10.10.1
Directory Information
SAP kernel  640	D:\usr\sap
SQL Server kernel (SP4)	C:\Program Files\Microsoft SQL Server\80, C:\Program Files\Microsoft SQL Server\MSSQL
SQL master,msdb,model,nothwide,pub ,tempDB and Log	C:\Program Files\Microsoft SQL Server\MSSQL\Data
SAP TPP Database and Log	D:\SAPDATA\TPPDATA1, D:\SAPDATA\TPPDATA2, D:\SAPDATA\TPPDATA3, D:\SAPDATA\TPPDATA4, D:\SAPDATA\TPPLOG1
Software SAP installation 4.7 and MS SQL and Patch	D:\software\SAP470\ CD_SAP_BW_3.1_Cont._Installation_Master, D:\software\SAP470\SAP470\IGS_J2EE D:\software\SAP470\SAPKernel_MSSQL, D:\software\SAP470\SAP470\MSSQL\MSSQL2K, D:\software\SAP470\SAP470\MSSQL\SQL2KSP4
Software SAPGui 6.4	D:\software\SAPGUI_v6.40

 
 Step by Step

-Install NBU client -Install Base MS SQL server -Restore database backup file PRD -Restore application data and kernel software  from NetBackup   Case RESTORE MS SQL SERVER DATABASE to new machine In Source Server (SP00) Edit script to new name machine From SQLHOST "sp00" to SQLHOST "tpc-bsr3ap81" And transfer script to new server -Wait Restore and recovery transaction log

Restore kernel  and restore task schedules from tape (if have)   from tape to server  Case RESTORE APPLICATION FILES to new machine Select destination server to new client Select destination directory to new temporary D:\usr_temp ->move D:\usr to D:\usr_org ->move D:\usr_temp to D:\usr