Home / Microsoft SQL Server (page 2)

Microsoft SQL Server

Logon to newly installed SQL 2008 R2

If you’re doing a system copy of a SAP System on top of Microsoft SQL Server 2008 R2 and you’re using a local admin other than Administrator, then you need to continue to read. Otherwise you can skip this blog and read other valuable blogs. Problem When you try to …

Read More »

Support package update for IDES

IDES on SAP ERP6 EHP6 on Windows 2008R2/MS SQL Server 2008R2 Common preparations; Performance tuning; Applying patches; I. IDES common preparations to update SP (support package). 1. SAP Kernel update Stop your SAP system, including any SAP services that were installed. Backup your kernel. Download the most recent kernel and …

Read More »

How to unlock SAP* user in Ms SQL database

Whenever SAP* user got locked (mainly in 000 Client), in most cases we are supposed to unlock the SAP* User in database level. Before logging into SAP system using SAP* user, be aware whether the parameter login/no_automatic_user_sapstar is set to value 0 (Zero). If the value of parameter login/no_automatic_user_sapstar is …

Read More »

Wondering why your transport tools …

…does not work after a system copy? Check note 1886616! 🙂 SAP Netweaver based systems uses two different variables sets, environment and profile variables. During a system copy those variables should be updated. If only the profile variables (<Unit>:usrsap<SID>SYSprofileDEFAULT.PFL) are updated, you will be able to start your SAP system …

Read More »

Log Shipping in SQL Server 2008 R2 for set BI on replicated database

High Availability – LOG SHIPPING High Availability Features ———————————— * In order to reduce or avoid server or database downtime so that the applications/users works continuously with the server, SS supports 3 types of DR features.                 1. Server Level High Availability features                                 * Clustering                 2. Database Level …

Read More »

Create a SQL linked server to ADSI

Recently my client asked me to run a promotion. They were moving code from development to QA and that too in a newly configured server. The promotion contained certain SQL scripts which queries the Active directory. But since there were no ADSI linked server created and configured, I had to …

Read More »

SCN Gamification

What do you think about the new SCN Gamification? If this is a complete strange topic for you, check Chip’s blog: We’re LIVE with #SCN Gamification!  #SCNGameOn Personally, I think this new platform will help the community. Do you have suggestions about any particular badge (or mission) we should have …

Read More »

Message Box ‘Installation failed’

Message Box “Installation failed” The unattended installation failed.   Installation Step: The unattended installation failed.   Return Code:       -2147024893   Log File:          D:WindowsSQL4SAP.log Check the log file above. See SAP note 1144459 for known issues. Result: vbOK

Read More »

Tune your SQL Server SAP Database

Hi again, In my last blog post I’ve already discussed a major topic for SQL Server databases, the common misconceptions. Now I want to elaborate on another topic which I come across very frequently… PERFORMANCE Performance-tuning is a very complex domain – good and deep knowledge and understanding of how …

Read More »

Have you ever …

… wondered why SQL Server behaves to weird 😕 Have you ever asked yourself questions like: why is my transaction log running full if I’m already using recovery model simple? how often should I update the statistics of the database objects? how often should I reorganize or rebuild tables and …

Read More »

Benifits of using SQL server 2008 (R2) for SAP

Features added in SQL server 2008 (R2)   Merge Command Backup Compression (optional) Transparent Data Encryption (optional) Changed Data Capture (optional) Star Join Optimization (BW) Grouping Sets (BW) Parallelism for partitions (BW) Row and Page compression Increased speed of partition drop: 15000 Partitions (SQL Server 2008 SP2 – feature notyet …

Read More »

DB Size decreased by 81%? Awesome

In my previous blog (How to Decrease Your SAP Database Size?) I gave all known options to decrease the Total DB size of SAP Solutions. The fastest and may be the cheapest method is using an alternative database software. The Dino’s in IT still doesn’t believe in databases other than …

Read More »

The others

Ok, I admit, I don’t have a very good idea of MS SQL Server. I do Oracle and MaxDB – that pretty much is it. Of course, as a database support guy you always need to peek over the fence to the other DBMS (e.g. working on priority Very High …

Read More »