restore Poduction server data on new prd

[Former Member]

HI All,

we have a PRD server on sap r3 4.7 with ms sql 2000 (OS windows 2003 32bit ) & also 2 instance ( central & Diaglog ) is running on same system. we took daily backup full backup & log backup after 30 min.

Due to short of resorces, now we want to shift our prd server to new server.

Please guide what is the easy way to build a new server.

can we install ms sql 2005 on new server ?
is this right way 

1 ) install ms sql 2005
2) install sap central instance with same sid as old prd
3) install diaglog instance on same prd server.
4) restore full backup of old prd
5) restore log of prd

Best Regards

Khan

[sunny_pahuja2]

Hi,

You should do the installation of dialog instance after system is up after restoring the database.

Thanks

Sunny

[Former Member]

Thanks Sunny,

can we Install  2005 ms sql & OS win 64bit on new server

what will be the sanario if we built complete new landscape using data of old landscape.

actullay we have DEV QAS PRD in landscape

same above procedure will adopt or some thing diff.

e.g 
after installating all SAP server and restoring data, what are things required to complete landscape or just restoring data will will automatically build landscape

Best Regards

Khan

[Former Member]

one thing more

SAP server installation through system copy and then restore backup  is easier than above senario

Regards

Khan

[sunny_pahuja2]

Hi,

You can do this with system copy using database specific method.

Thanks

Sunny

[Former Member]

Thnaks,

we will do the following , plz correct us if some thing wrong.

1 ) on source system export db using syscom copy

2) install ms sql 2005 on target system.

3) install SAP system using source system export.

4) restore lastest backup of source system.

Plz guide how & which folder we will use from <drive>:\usr\sap folder of souce system or we can ignore this ?

please clear me , can we istall ms sql 2005 on target system, while source system has ms sql 2000

Regards

Khan

[Former Member]

Dear Imran,

When you are planning for performing database upgrade from 2000 to 2005 you have to check SAP requirement.

i.e. You sap basis patch level, For SQL Server 2005, only the BIN2 collation ( SQL_Latin1_General_CP850_BIN2 ) is permitted for all systems (Unicode, non-Unicode, Java or non-Java). The BIN collation is no longer supported.

If you ask me i suggest.

1. prepare your source database and application ready for MS SQL 2005

2. Use database specific method for backup and restore. as per sap system copy guide.

3. install OS and MS SQL 2005 on target system

4. install CI as per sap system copy guide with database restore

5. perform post system ready activity as per sap system copy guide

6. install DI

Regards,

Nikunj Thaker

[sunny_pahuja2]

Hi,

why you want to export if you are using database specific method. Is the system is dual stack or single stack ?

I will suggest you to go through the system copy guide.

Thanks

Sunny

[Former Member]

system is single stack but with 2 instance (central & diaglog) on same system.

[sunny_pahuja2]

Hi,

You cannot export dialog instances. After system copy you need to reinstall the dialog instance.

Thanks

Sunny

[former_member182505]

Hi Imran,

fallow the sap note no 151603.

its will help to setup your problem,

thanks