<style>p { margin: 0; }span.fr-emoticon.fr-emoticon-img { background-repeat: no-repeat !important; font-size: inherit; height: 1em; width: 1em; min-height: 20px; min-width: 20px; display: inline-block; margin: -0.1em 0.1em 0.1em; line-height: 1; vertical-align: middle; } span.fr-emoticon { font-weight: normal; font-family: "Apple Color Emoji", "Segoe UI Emoji", "NotoColorEmoji", "Segoe UI Symbol", "Android Emoji", "EmojiSymbols"; display: inline; line-height: 0; } blockquote { border-left: solid 2px #5e35b1; color: #5e35b1; margin-left:0; padding-left:5px;}blockquote blockquote{ border-color: #00bcd4; color: #00bcd4;}blockquote blockquote blockquote{ border-color: #43a047; color: #43a047;} table.grid{ border-collapse: collapse;} table.grid td, table.grid th { border: 1px solid #ddd;} .fr-fic.fr-dib{ display: block; margin: 5px auto;}.fr-fic.fr-dib.fr-fir{ text-align: right; margin: 5px 0 5px auto;}.fr-fic.fr-dib.fr-fil{ text-align: left; margin: 5px auto 5px 0;}.fr-fic.fr-dii{ float: none; margin: 5px auto;}.fr-fic.fr-dii.fr-fil{ float: left; margin: 5px auto;}.fr-fic.fr-dii.fr-fir{ float: right; margin: 5px auto;}img.fr-dib.fr-fir { margin-right: 0; text-align: right;}img.fr-dib.fr-fil { margin-left: 0; text-align: left;}img.fr-dib { margin: 5px auto; display: block; float: none;}img.fr-bordered { box-sizing: content-box; border: solid 5px #CCC;}img.fr-shadow { box-shadow: 10px 10px 5px 0px #cccccc;}img.fr-rounded { border-radius: 10px; -moz-border-radius: 10px; -webkit-border-radius: 10px; -moz-background-clip: padding; -webkit-background-clip: padding-box; background-clip: padding-box;}</style><p>This guide will show you how to restore a database backup.</p><p><br></p><p><em id="isPasted">This guide only applies if you are running Halo yourself, On-Prem.</em></p><p><br></p><p id="isPasted"><strong><span style="font-size: 12pt; color: rgb(226, 80, 65);">Warning</span></strong></p><p>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:</p><p><br></p><p>SELECT rdbversionweb FROM CONTROL;</p><p><br></p><p><br></p><p id="isPasted"><strong><span style="font-size: 12pt;">Prerequisites</span></strong></p><ul><li>You must have access to your database server through a DB client, typically SSMS.</li><li>You must have a .bak backup file of your database.</li></ul><p><br></p><p><br></p><p><strong id="isPasted"><span style="font-size: 12pt;">Restoring the DB</span></strong></p><ol><li>Login to SSMS with an account which has permissions to perform a restore</li><li>Stop the Halo app in IIS</li><li>Go to restore on the database:<img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjA0NTUyMzFlLWU4MmEtNDkwOC04YWIyLTY3ZjRhODMxOWZjYSJ9.RKtaYlwI0Bdm-AsmY5jfCNc7yKbNhp5b1mW6bCmOHKI" class="fr-fic fr-fil fr-dib" width="777" style="width: 779px; height: 596.231px;" height="596" alt="Image of MS SSMS showing the path to restore a database"></li><li>Find the backup file and then select the database to restore to and click ok:<img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImZhMzA3YmZhLWExNTMtNDA4YS05YThiLTM2NmRjMGExOTQzOSJ9.BWpgmlQtlItolaPQ3XIS-RJ_NaEYil4vDvCDL654K-w" class="fr-fic fr-fil fr-dib" width="781" style="width: 783px; height: 657.72px;" height="658"></li><li>If there is a version change between the database and the webapp, you will need to upgrade the database. This can be done by going to your Halo root directory and running the 'Upgrader.exe':<img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImJjODBjMmJmLTA1YTItNDEzZC1hOWI0LWUwYzc4MmUyM2NjYiJ9.KPCNybrxVgNGi1mko6ZKN1LsEGjQBj4Y3twixSqcFDY" class="fr-fic fr-fil fr-dib" width="994" style="width: 996px; height: 487.557px;" height="488"></li><li>You can now restart the site in IIS and it should load correctly</li><li>Make sure the URL in NHD_IDENTITY_Application matches up with the url of the application</li></ol><p><br></p><p><strong id="isPasted"><span style="font-size: 12pt;">Troubleshooting</span></strong></p><ul><li>Please ensure that your DB user still has permission to your restored database</li></ul>
