On-Prem Database
3 guides
Checking your DB Size
The article provides a step-by-step guide to check the size of an on-premise Halo database. It includes a SQL query that retrieves database details such as schema names, table names, row counts, and space usage in megabytes and gigabytes. The query calculates total, used, and unused space for non-system tables. It includes joins on system catalog views for detailed storage information and orders results by total space.
On-Prem Instance to Instance Refresh
This article provides a detailed guide on refreshing a Halo on-premise instance from another on-premise instance, such as copying a production instance to a UAT/Dev instance. It involves gathering specific database information, backing up the source database, and restoring it to the destination instance after stopping it in IIS. It includes steps for setting necessary keys and URLs, and instructions for upgrading the database if needed. The process finishes by restarting the site in IIS.
Restoring a DB Backup
This guide instructs on restoring a database backup for Halo on-premise. Ensure the backup's database version is the same or older than the Halo app version. Prerequisites include access to the DB server via a client like SSMS and a .bak file. The process involves stopping the Halo app in IIS, using SSMS to restore the DB, and upgrading the DB if there's a version change. Finally, ensure the application's URL matches in configurations. Troubleshoot by verifying DB user permissions post-restoration.