In my last blog I stated I wanted to implement the AlwaysOn Availability Groups with SQL Server 2016 and I would try the new automatic seeding option. I always found tedious to manually backup the database and restore on other replicas to finally joi...
In a recent support case, a customer asked whether it would be possible to create an External Database Connection from ABAP (DBCON) to a SQL Server AlwaysOn Readable Secondary Replica.
Short explanation about AlwaysOn: AlwaysOn Availability Groups i...
Since SAP released the support for SQL Server 2016 to some products based on SAP NetWeaver - not all products are currently supported, see SAP Note 2201059 - I was preparing my test systems to upgrade to SQL Server 2016. I took me 2 days to complete ...
I replied this to this question:https://answers.sap.com/questions/27581/mssql-server-agent-job-sap-sid-sid-mssql-collector.htmlRight after answering it, I didn't see the reply. I wondered why the answer was not there, then I replied again, with simil...
We recently received some incidents from customers having problems to finish their database upgrade on SQL Server.An essential part of upgrading SQL Server is running the Database Upgrade Completion, part of the SAP Tools for MS SQL Server, which is ...
Hi Alagesa,The error message in questions means that your SAP HANA system is not able to start the indexserver for the NDB tenant. There can be many possibilities for that to be happening, so there is no 1:1 problem solution for you at this point.My ...
Hi Mithran,Since you have mentioned you're not restoring the database from a backup, it means you'll have to install a new system. This is a new installation, so you don't have to perform any action besides following the installation guide for the ne...
saphana_suresh Great to hear that the answer helped you! Please make sure to mark the answer as correct to help others to find this solution when searching in the future!
You won't be able to do this join within an Analytical View. A self-join would be supported in the context of a logical join only, and as per the documentation, you can perform a self-join within Attribute Views.