Ask the Community
Groups
Migration of Kaseya Server and the Database - Connect IT Community | Kaseya
<main> <article class="userContent"> <h3 data-id="question">Question</h3> <p>I would like to migrate my current Kaseya application server and my database to a new server. What are the steps I need to take?</p> <h3 data-id="answer">Answer</h3> <p>Although we have a detailed guide on how this can be achieved in our help file <a href="/home/leaving?allowTrusted=1&target=http%3A%2F%2Fhelp.kaseya.com%2Fwebhelp%2FEN%2FVSA%2F9050000%2FInstall%2Findex.asp%236716.htm" rel="noopener nofollow">here</a>, this article has been written to provide summarized points that you need to take for the migration.</p> <ul><li>This article assumes that you have migrated all of the KAV/KAM Classic installations to the new module prior to migrating.</li> </ul><p><strong>Note: </strong>The KAV/KAM Classic Module <em>will not</em> be installed in new installations of VSA 9.3 or higher.</p> <ul><li>This article assumes that you will use the same IP for the new server as the one being used by the old server or that you will point the current DNS address agents are using under "Agent > Check-in Control" to this new server's IP.</li> <li>This article also assumes that the Kaseya application along with the database is on the same server.</li> </ul><p>If you are looking to migrate from the same server to two different servers (i.e different front end and different SQL server) then please follow instruction from <a href="https://kaseya.vanillacommunities.com/kb/articles/aliases/kaseya/entries/32036893-How-do-I-move-SQL-and-the-Ksubscribers-database-to-another-computer-" rel="noopener nofollow">this article</a> in order to migrate the database - also the steps related to transfer of ManagedFiles and UserProfiles can be found in the list below.</p> <p>If you are looking to migrate from the existing split set up to a new split set up servers, please follow our <a href="/home/leaving?allowTrusted=1&target=http%3A%2F%2Fhelp.kaseya.com%2Fwebhelp%2FEN%2FVSA%2F9050000%2FInstall%2Findex.asp%236716.htm" rel="noopener nofollow">help file</a> in detail.</p> <div> </div> <div> <strong>On your OLD Server</strong><br><br><strong>1.</strong> Important, please make a note of the <strong>same</strong> <a href="/home/leaving?allowTrusted=1&target=https%3A%2F%2Fmsdn.microsoft.com%2Fen-nz%2Flibrary%2Fhh230914.aspx" rel="noopener nofollow">collation</a> of the ksubscribers database had on the old server per the notes from <a href="https://kaseya.vanillacommunities.com/kb/articles/aliases/kaseya/entries/36045557-Error-message-Collation-of-Latin1-General-CI-AS-which-does-not-match-the-KSubscriber-database-" rel="noopener nofollow">this article</a>.</div> <div> </div> <div> <strong>2.</strong> Next, backup the ksubscribers database via 'System > Server Management > Configure > Backup Now button' and copy this completed backup to a backup folder. (Example: 'D:\KaseyaServerBackup'). </div> <div> </div> <div> <strong>3.</strong> Please stop all the Kaseya services on the OLD server</div> <div> <br><strong>4.</strong> Copy 'C:\Kaseya\WebPages\ManagedFiles' and all sub-directories (<strong>Important: </strong>Excluding 'VSAHiddenFiles') to the same backup directory. (Example: 'D:\KaseyaServerBackup\ManagedFiles').<br><br><strong>5.</strong> Copy 'C:\Kaseya\UserProfiles' and all sub-directories to the same backup directory. (Example: 'D:\KaseyaServerBackup\UserProfiles').<br><br><strong>6.</strong> Copy 'C:\Kaseya\EndpointDownloads' and all sub-directories to the same backup directory. (Example: 'D:\KaseyaServerBackup\EndpointDownloads').<br><br><strong>7.</strong> Copy 'C:\Kaseya\EndpointUploads' and all sub-directories to the same backup directory. (Example: 'D:\KaseyaServerBackup\EndpointUploads').<br><br><strong>Note: </strong>After securing the important files, please proceed with the below steps.<br><br><strong>On your NEW Server</strong><br><br><strong>1.</strong> Install SQL using the <strong>same collation</strong> as the ksubscribers database had on your OLD server.<br><br><strong>2.</strong> Download the Kaseya installer - <a href="/home/leaving?allowTrusted=1&target=http%3A%2F%2Fdownload.kaseya.com%2FKInstall.exe" rel="noopener nofollow">http://download.kaseya.com/KInstall.exe</a><br><br><strong>3.</strong> Run through the installer to install Kaseya without any data. (<strong>Important: </strong>The same VSA version that your OLD server has should be installed on the NEW server).<br><br><strong>4.</strong> Stop all the Kaseya services except for the 'Kaseya.ApplicationFirewall' or 'Kaseya Edge Services' and the 'Kaseya Web Exec'.</div> <div></div> <div> <strong>5. </strong>Copy 'UserProfiles' and all sub-directories from your backup directory. (Example: 'D:\KaseyaServerBackup\UserProfiles' to 'C:\Kaseya\UserProfiles'). Drive letter needs to be maintained, as the reference in the database will be from the old server.</div> <div> <br><strong>6.</strong> Copy 'ManagedFiles' and all sub-directories (excluding 'VSAHiddenFiles') from your backup folder. (Example: 'D:\KaseyaServerBackup' to 'C:\Kaseya\WebPages\ManagedFiles'). Drive letter needs to be maintained, as the reference in the database will be from the old server.<br><br><strong>7.</strong> Copy 'EndpointDownloads' and all sub-directories from your backup folder. (Example: 'D:\KaseyaServerBackup\EndpointDownloads' to 'C:\Kaseya\EndpointDownloads'). Drive letter needs to be maintained, as the reference in the database will be from the old server.<br><br><strong>8.</strong> Copy 'EndpointUploads' and all sub-directories from your backup folder. (Example: 'D:\KaseyaServerBackup\EndpointUploads' to 'C:\Kaseya\EndpointUploads'). Drive letter needs to be maintained, as the reference in the database will be from the old server.<br><br><strong>9.</strong> In SQL Management Studio, <a href="/home/leaving?allowTrusted=1&target=http%3A%2F%2Fwww.howtogeek.com%2F50354%2Frestoring-a-sql-database-backup-using-sql-server-management-studio%2F" rel="noopener nofollow">restore the database</a> that you previously copied to the backup folder. Please make sure you choose to overwrite the existing database from options tab in restore window</div> <div> </div> <div> <strong>10.</strong> In SQL Management Studio, locate a user with the name starting "KaseyaVSA" and map it to newly restored ksubscribers database:</div> <div> </div> <div><img src="/attachments/token/G2KtgrSVMHSLJeJEFc7fPdLB2/?name=2015-06-05+11_52_06-%5E8302EDCE9643CA31AEC31830923ADF090CC0BFD0085B98D267%5Epimgpsh_fullsize_distr.jpg+-.png" alt="2015-06-05_11_52_06-_8302EDCE9643CA31AEC31830923ADF090CC0BFD0085B98D267_pimgpsh_fullsize_distr.jpg_-.png" width="793" height="514" class="embedImage-img importedEmbed-img"></img></div> <div> <br><strong>11.</strong> Once complete, click the "Start menu > Programs > Kaseya > Reinstall Database Schema". <br><br></div> <div> <strong>12.</strong> Verify that schema runs and completes without any errors and check if you can log in. If you receive any schema errors or have any issues logging in please <a href="https://kaseya.vanillacommunities.com/kb/articles/aliases/kaseya/hc/en-gb/requests/new" rel="noopener nofollow">contact Kaseya Support</a> immediately and select <strong>Service(s) Down </strong>for the "Issue Severity" after selecting the "Kaseya Support" form.</div> <div> </div> <div><img src="https://us.v-cdn.net/6032361/uploads/migrated/YBJ5PJVU9VGM/ss.png" alt="SS.png" width="467" height="358" class="embedImage-img importedEmbed-img"></img></div> <div> </div> <div> <strong>13.</strong> If you are able to log in, the next thing to do would be to check your agents' check-in address. Since your agents should be checking in with the other IP you had for the OLD server then this would need to be reviewed/updated if needed. Simply navigate to <strong>Agent > Configure Agents > Check-in Control</strong> and verify the <strong>Primary </strong>/ <strong>Secondary KServer </strong>for your agents here.</div> <div> </div> <div> <strong>Note: </strong>Since this NEW server should now have the same IP address, agents should be online and checking in, if they are not, note that the DNS should be pointed to this NEW server IP address.</div> <div> </div> <div> <strong>14. </strong>Lastly, please verify the correct permissions are set under directory path 'C:\Kaseya\WebPages' for the users <strong>IUSR</strong> and <strong>IIS_USRS</strong>:</div> <div> </div> <div><img src="/attachments/token/Lh6WJUjS8noVh9c1Wemsv8Bkb/?name=inline732599076.png" alt="image" class="embedImage-img importedEmbed-img"></img></div> <div> </div> <div> <strong>NOTE</strong>: TAP modules for Kaseya products, please reach out to Support as some require a new registration.</div> <div> <strong>Applies to:</strong> All VSA Versions.</div> </article> </main>