2 DB instances - 1 SAP application server

[Former Member]

Hello All,

  Can I connect to two different database servers/instances parallelly to one application server(SAP)?

  Does it not create a problem in accessing the content of table with the same name on different database servers/instances?

  If answer to above is yes where in the basis should I do it?

  There's a big database table where the data needed to be moved but still accessible to SAP server. Archiving is not a solution for us 

Thanks

[luisdarui]

Hi Cisco,

1) You can connect your SAP application server to an external database running SQL Server through DBCON: Note 1601608, and also this blog post:

2) Or do you mean you want to have 2 different back-end database servers while your application server switch between then?

In case of 2), I'm not sure this will work and it is mostly not supported by SAP.

Regards,

Luis Darui

SAP Support

[Former Member]

Hi,

Hope the requirement is just for the single table to be moved out of the SAP database. Not sure why archiving is not applicable because you can still able to access the content of the table after archiving is done.

Regards,

Raja. G

[Former Member]

Yes! Raja its only for one ztable with clog and blog fields.

[Sriram2009]

Hi Cisco

  You can perform Normal SAP instalaltion either Standalone or Distributed system with MS Sql 2012 DB, and do the DB replication to another instance using MS Sql 2012 Alwayon with 4 secound replication, refer the Microsoft link and SAP Note

Overview of AlwaysOn Availability Groups (SQL Server)

1772688 - SQL Server AlwaysOn and SAP applications

Regards

SS

[Former Member]

Hi Cisco,

In that case i would prefer to go with archiving as you can still access those contents and able to use the table at SAP level. Otherwise you can consider using the external database as mentioned by Luis and Sriram, it depends upon the usage of the table and the complexity.

Can you let us know why are you not prefer for archiving as it is the standard approach for growing tables?

Regards,

Raja. G