Microsoft SQL Server

Upgrade to and Installation of SQL Server Guides moved to SAP Help Portal

Hi everyone, Where can you find the “Upgrade to and Installation of SQL Server 2008(R2)/ 2012/ 2014/ 2016 in an SAP Environment” Guides? They have been moved from the SAP Service Marketplace to the SAP Help Portal. You can find them here: SQL Server Release PDF HTML 2008 (R2) here https://help.sap.com/viewer/upgrade_sql2008 2012 here https://help.sap.com/viewer/upgrade_sql2012 2014 here https://help.sap.com/viewer/upgrade_sql2014 2016 here https://help.sap.com/viewer/upgrade_sql2016   You can also find these guides via the SAP NetWeaver GuideFinder. …

Read More »

SQL Server 2016 AlwaysOn with Automatic Seeding option

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 join them in the Availability Group. First of all, you should read Juergen’s blog post on Running SAP on Microsoft Platform blog to understand the new features and …

Read More »

Using DBCO with Microsoft SQL Server AlwaysOn Readable Secondary Replicas

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 is an HA/DR feature introduced on SQL Server 2012 that, among all other important things (which aren’t the object of this blog post, but feel free to read more about here and here), allows you …

Read More »

Upgrading my SAP NetWeaver system to SQL Server 2016

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 all the necessary steps to upgrade the database to SQL Server 2016. My system is a SAP NetWeaver 7.50 (initial shipment, no SPS), ABAP …

Read More »

Query to check MS SQL restoration/Backup percentage

We can use below select command to check backup/restoration percentage.  We can execute this query when MS SQL Backup or restoration is in progress. Also this query will show the processes which are running in DB (Backup, Restore, rebuild, compression) =========================================== SELECT command, s.text, start_time, percent_complete, CAST(((DATEDIFF(s,start_time,GetDate()))/3600) as varchar) + ‘ hour(s), ‘ + CAST((DATEDIFF(s,start_time,GetDate())%3600)/60 as varchar) + ‘min, ‘ + CAST((DATEDIFF(s,start_time,GetDate())%60) as varchar) + ‘ sec’ as running_time, CAST((estimated_completion_time/3600000) …

Read More »

SAP Tools for MS SQL Server update – SAP NW on SQL Server PS blog

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 delivered within SWPM. It will perform many SAP specific tasks and will also increase the database compatibility level. During the execution, the error was always the same, in sapinst_dev.log: …

Read More »

Remote connection to SQL Server database from SAP NetWeaver

Often in Product Support, we receive support incidents asking how to remote connect to a SQL Server database. SAP NetWeaver (and all Business Suite systems based on NetWeaver, including SolMan) can connect to a database through 2 different options: DBCON/Multiconnect (ABAP Stack) and UDConnect (JAVA Stack). This is explained in SAP KBA 1601608 – How to access an external SQL Server database. UDConnect UDConnect can be used for BW/BI purposes, …

Read More »

Extract info from SQL Server to MsExcel

Hi all. I want to share with you, what do you do to extract info from SQL Server to MsExcel. You have to follow this steps: 1.- create a New View in SQL. You have to write a query (this is a single example): SELECT docnum, doctotal, cardcode, cardname FROM OINV WHERE docdate between getdate()-30 and getdate() this query show you the invoices saved in last 30 days. 2.- Go …

Read More »

script to make a SQL server database backup

Hi all. I want to share this scritp. Whit this one you can make a SQL Job and scheduler it to execute the backup on a specific date and time. I wish It help us. Best regards. Saul. USE [YourDataBase] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE procedure [dbo].[SP_CrearBackupsDiario] --This script create a backup of every database. --This script use a cursor that go one by one …

Read More »

Video Articles for SAP NW on SQL Server

You probably have heard that SAP Product Support is creating Knowledge Base Articles with embedded videos. Our Product Support team is now working on to create articles with videos to help customers and partners on how to perform specific tasks, troubleshoot, etc. We added recently a specific wiki page in our SCN Wiki SAP on SQL Server to list these articles, in order to facilitate users who are navigating to …

Read More »

Do you want to Get SAP Courses?

Get SAP Courses and Training, Videos, Other Useful Resources
Join Now
Written by SAP Expert TEAM.
close-link
New Registration