SQL Server: reduce the size of the transaction log

In this “troubleshooting” tutorial, we will see how to reduce the transaction file (ldf) of a SQL Server database. Normally this file is truncated during server backups (Veeam, Altaro …) or by the maintenance plan. In certain situations with SQL Express, the “truncation” is not done and if the size of the file is badly …

Read more



Veeam Backup Office 365 – Installation and use

Introducing Veeam Backup Office 365 Veeam Backup Office 365 is a software which allows the backup of mailboxes hosted on Office 365. It is also possible to backup a local Exchange with. Installation 1. Download Veeam Backup Office 365 from the site veeam.com 2. Unzip the archive. 3. Launch the executable 1. 4. Click on …

Read more



PRTG: supervision of MSA arrays

systemonitor

In this tutorial, we will see how to supervise an HP MSA 1040/1050/2040/2050 storage array. Prerequisites You must create an equipment group in PRTG to add the two controllers. Supervision of MSA disk array All the sensors were created from the PRTG web interface. Controller A Click on Add a device 1. Give a name …

Read more



GLPI: SSO with IIS – Single sign-on

In this article, I will explain how to implement SSO (Single Sign-On: Single Authentication) with GLPI installed with IIS. SSO saves the user from having to enter identifiers to connect to GLPI. Prerequisites Site configuration in IIS Open the IIS console, go to the GLPI site 1 and click on Authentication 2. Select Anonymous Authentication …

Read more



GLPI link with an Active Directory

In this article, we will see how to configure GLPI with an Active Directory so that users can identify with their Windows session name and password. Configuration of the Active Directory in GLPI From the navigation menu go to Configuration 1 > Authentications 2. In the External Authentications list, click LDAP Directories 1. Click on …

Read more



GLPI on IIS: configuration and installation

In this tutorial, I will explain how to prepare the Windows environment to install GLPI under IIS and how to configure GLPI to send email using an SMTP server. Prerequisites Have the IIS role installed on a server. Install PHP on IIS. A MariaDB or MySQL server. Download the latest version of GLPI. Have an …

Read more



Veeam: Resolving the Volume Problem of Backups on Deduplicated Servers

Symptom On Windows servers with deduplication enabled, at regular intervals the backup size is increased. Below are several screenshots showing the problem: Reason The problem is not with Veeam software, but with deduplication on Windows Server. When configuring deduplication, a memory cleanup job is configured to optimize deduplication, by default this is done every Saturday …

Read more



OneDrive OnPremise with SharePoint

Open folder

OneDrive is Microsoft’s tool for storing information in the cloud and having a synchronized copy on your computer. This solution is increasingly used by individuals to save their data, so we are left with users who uses their personal drive to store professional files. OneDrive is available in Office 365 offers, in company you may …

Read more



MariaDB : Access denied for user ‘root’@’localhost’

Just after installing MariaDB on Ubuntu / Debian, this error may appear if you try to connect with phpMyadmin. To solve / work around the problem, we will create another user with the same level of rights as root. 1. Open an SSH connection on the server. 2. Enter the following commands: 3. Restart the …

Read more



Sharepoint 2013 foundation: installation and configuration

Introduction In this tutorial, we will see how to set up Sharepoint 2013 foundation on Windows 2012R2. Although this version at the time of writing this article is more than 5 years old, it allows to discover Sharepoint before making its acquisition. SharePoint is a web portal that allows to set up within a structure …

Read more