2 Replies Latest reply on Oct 13, 2020 11:49 AM by Marmik Mishra

    Import ORS-START TO DROP DB

    Amit Saini Active Member

      We are trying to import ORS in the MS SQL Server. After creating the ORS running the command

      Database\mssql>create_cmx_ors.bat import_ors

      Note: we don’t have sip_ant.bat file

      Logs

      Changed database context to 'master'.

      START TO DROP DB

      Changed database context to 'master'.

      Changed database context to 'master'.

      Changed database context to 'master'.

      MSSQL DB add_cmx_ors READ_COMMITTED_SNAPSHOT ON

      Dropping login add_cmx_ors

      Changed database context to 'add_cmx_ors'.

      Changed database context to 'master'.

        • 1. Re: Import ORS-START TO DROP DB
          Anuvinda Kulkarni Seasoned Veteran

          Hello Amit,

           

          Any reason why you don't have sip_ant.bat file?

           

          Thanks.

          • 2. Re: Import ORS-START TO DROP DB
            Marmik Mishra New Member

            Hi Amit,

             

            The logs you shared -

             

            Changed database context to 'master'.

            START TO DROP DB

            Changed database context to 'master'.

            Changed database context to 'master'.

            Changed database context to 'master'.

            MSSQL DB add_cmx_ors READ_COMMITTED_SNAPSHOT ON

            Dropping login add_cmx_ors

            Changed database context to 'add_cmx_ors'.

            Changed database context to 'master'.

            These logs are generated when you create an ORS with the name already existing in database. In your case, add_cmx_ors already exists in database and again you are running create_ors script and creating new ORS named add_cmx_ors.

            Could you please share the logs generated before the below mentioned line, it will give detail about which SQL script is running -

             

            Changed database context to 'master'.

            START TO DROP DB