SQL Server Restore a Database from a Backup (BAK)

Lauch restore

In this tutorial, I will show you how to restore a SQL Server database from a backup file (BAK). To perform the restore, you must have SQL Server Manager Studio (SSMS). Restore a database In order to find the backup files, I copied them to the Backup folder of the SQL Server installation, which is …

Read more



MDT: use with a database

New computer

In this tutorial, we will see how to use MDT with a database. The use of this one makes it possible to store in a database the information of deployment for a station to identify for example by its MAC address, which makes it possible when one has to redo the post to pre-fill all …

Read more



PRTG: equipment dependent on a parent

Save

PRTG allows you to create dependencies between multiple devices. This allows in case of failure of a device to pass the others automatically paused. This parameter can be used with servers and a switch. In this tutorial, we will use it to bind a server to a database instance. If on a server, there are …

Read more



Exchange 2019: Add a database

Exchange 2019 : databases

Using multiple databases to store mailboxes allows you to configure a different volume. Example: The DBMX01 database stores mailboxes with a 1GO quota and the DBMX02 database stores mailboxes with a 5GB quota. With this configuration, simply move the box from one base to another to change the volume. Add a database 1. On the …

Read more



Optimize the space of SQL Server databases

Start optimization

In this tutorial I will show how to optimize the space used by databases. The optimization of the space is done in two stages: On the database: internal data optimization On files: reducing the size of the files on the disk. It is recommended that you perform these operations after deleting a large amount of …

Read more



Exchange 2016: how to set up a DAG

In this tutorial, we’ll see how to set up a Database Availability Group (DAG) that makes the Exchange Highly Available (HA) databases available. This feature of Exchange makes it possible to put the databases that host the mailboxes in high availability, the databases replicate in “real time”. This solution ensures high availability of Exchange messaging …

Read more



Exchange : Fix Index Issues

Symptom In the ECP interface, the index status of the database is failing. The Get-MailboxDatabaseCopyStatus command returns the ContentIndexState Fail or FailedAndSuspended field. Solution 1. Stop the MSExchangeFastSearch and HostControllerService services. Stop-Service MSExchangeFastSearch Stop-Service HostControllerService 2. Open the Windows Explorer and go to the folder where the database file is stored. Delete the folder {guid] …

Read more



Exchange change a database mailbox

In this tutorial, we will see how to change a database mailbox. This is done regularly in Exchange environments with multiple databases with different quotas (limits). Moving the mailbox allows it to have the new quotas linked to the database unless the limits have been changed directly from the box settings. Move the mailbox 1. …

Read more



GLPI 9.3 convert tables to innodb

Presentation Since version 9.3 of GLPI, the new installations use the InnoDB storage format instead of MyISAM. When updating your GLPI, the tables will not be automatically migrated. The migration must be done by hand. When connecting to your site you will have an alert message telling you that tables are not in the correct …

Read more