Author Archives: cms4j

Elfriede lebe hoch!

Szenario. Sie sind DBA einer IT-Firma, die ein Tickettool einsetzt, um Geschäftsprozesse abzubilden. Nach Jahren ist das Datenvolumen der Datenbank auf mehr als 250 GB angewachsen. Elfriede vom Controlling hat mit den SQL Server Reporting Services mehrere komplexe Berichte implementiert. … Continue reading

Posted in #Elfriede, SQL Server, Uncategorized | Leave a comment

Shrink an SAP database “online”.

Shrinking is bad First of all: shrinking a database is nothing that you should do on a regular basis, like using this step in a Maintenance Plan or setting it up yourself via SQL Server Agent Jobs. But if the … Continue reading

Posted in Uncategorized | 1 Comment

SQL Server 2008 R2 Installation Failed -2068052081, 1212, 1935

Today: Server Team provided Windows Server 2008 Service Pack 2, Build 6002 Installation of SQL Server 2008 R2 failed with this message: Overall summary: Final result: SQL Server installation failed. To continue, investigate the reason for the failure, correct the … Continue reading

Posted in Uncategorized | Leave a comment

0x851c0001 – the credentials you provided for the ‘SQLSERVERAGENT’ service is invalid.

We always install SQL Server with configuration.ini files to be sure that each and every server looks like the other. Today we received the error message: (01) 2016-11-29 14:23:47 Slp: Exception type: Microsoft.SqlServer.Chainer.Infrastructure.InputSettingValidationException (01) 2016-11-29 14:23:47 Slp: Message: (01) 2016-11-29 … Continue reading

Posted in Uncategorized | Leave a comment

Log chain broken? How to deal with backups from the future.

Today (2015-10-05) we had to deal with an interesting phenomenon. Backups from the future breaking the log chain! Problem Our third party software solution that is responsible for backup and restore tried to take a transaction log backup of a … Continue reading

Posted in Backup, SQL Server | Leave a comment

Create failed for Availability Group Listener

Problem Today I tried to create an AlwaysOn Availability Group. Everything went fine until I configured the Availability Group Listener. It failed with the error message: Create failed for Availability Group Listener <ListenerName>. Microsoft SQL Server, Error 19471. The Windows … Continue reading

Posted in AlwaysOn Availability Groups, SQL Server, Uncategorized | Leave a comment

redgate SQL Monitor – The RPC Server is unavailable

Lucky me, I am setting up redgate SQL Monitor to monitor SQL Server Instances. First to say – as ever – redgate is developing ingeniously simple tools. So the installation just took minutes, the services on one VM, the repository database … Continue reading

Posted in SQL Server | Leave a comment