cancel
Showing results for 
Search instead for 
Did you mean: 

Rename SAP SID without using system copy

Former Member
0 Kudos

Hello All,

I am in urgent need of renaming my SAP SID to something else we had in the past but i don't have time to do a system copy and create a new system from that. Can any body please help me by providing steps to achieve the same.

Regards

Mandeep

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Unfortunately I believe that is not possible to change the SID without system copy.

You do find the official in formation in note 11692

11692 Renaming the system ID

Clébio

Answers (5)

Answers (5)

Former Member
0 Kudos

Here you can use database specific option as well.

1) Detach the database

2) Uninstall existing SAP instance

3) Attach database with new SID

4) Execute SAP tools for SQL to rename the SID

5) Install SAP instance (with new SID)

Regards,

Nick Loy

deeraj_shetty
Participant
0 Kudos

Hi Mani,

Now its possible to change SAP SID, DB SID and host name using system rename 1.0 tool.

You download the latest version of documentation and latest version of system rename 1.0 from SAP Service Marketplace at http://service.sap.com/sltoolset ->Software Logistics Toolset 1.0

Regards,

Deeraj Shetty

xymanuel
Active Participant
0 Kudos

Hi Mani, hopfully you dont try this is with an productive system, because this is not supported.

I think you want to do a Q System refresh (QRD) out of the productive (PRD).

In Windows MSSQL you can do (according to the mentioned note :

1. Restore PRD to QRD, or detach the restored PRD.

2. Attach as QRD

3. Run MSSQL Tools, which you can download from the Marketplace. They will do the rename of the DB schema.

4. Run BDLS in all Clients (e.g. 000 + 100).

Be sure you did all the steps mentioned in the systemcopy guide.

Kind regards

Manuel

Former Member
0 Kudos

hi

u can perform system copy procedure to rename the sid......

Former Member
0 Kudos

Hi,

You can use MS-SQL Attach/Detach method for System Copy.

It will take less time...

Just search and read System Copy guide (Attach/Detach) method on SMP.

Regards.

Rajesh Narkhede