Skip to Content
avatar image
Former Member

Rename SAP SID without using system copy

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

6 Answers

  • Best Answer
    Feb 12, 2012 at 10:40 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 13, 2012 at 11:13 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 07, 2014 at 07:26 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 17, 2012 at 01:31 PM

    hi

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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 20, 2012 at 02:29 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 07, 2014 at 10:41 AM

    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

    Add comment
    10|10000 characters needed characters exceeded