On Premise Migration

This guide will show you how to migrate your on-premise instance of Halo to a new Server.  This only applies if you are running Halo yourself, on-premise. Prerequisites: You must ensure the new server you are migrating to meets the requirements set in this guide Importantly you will not need to extract the nhdweb files […]

Checking your DB Size

This guide details how you can check your On-Premise Halo database size. Please run the below query directly on your Halo database: SELECT s.name AS SchemaName, t.name AS TableName, SUM(p.rows) AS RowCounts, — Total space in MB and GB CAST(SUM(a.total_pages) * 8.0 / 1024 AS DECIMAL(10,2)) AS TotalSpaceMB, CAST(SUM(a.total_pages) * 8.0 / (1024 * 1024) […]

On-Prem Instance to Instance Refresh

The guide will detail how you can refresh your Halo On-Prem instance with that of another On-Prem instance, such as a production instance to a UAT / Dev instance. Throughout this guide I will reference the two instances as below: Source: The instance you are copying from Destination: The instance you are copying to Information […]

Restoring a DB Backup

This guide will show you how to restore a database backup. This guide only applies if you are running Halo yourself, On-Prem. Warning You must ensure that the database backup is using a database version the same as or older than your Halo app version. You can find the database version using the below command: […]