Ask the Community
Groups
How do I move SQL and the Ksubscribers database to another computer? - Connect IT Community | Kaseya
<main> <article class="userContent"> <p><strong>KB#: KKB000706</strong></p> <p><strong>QUESTION</strong></p> <p>How do I move SQL and the Ksubscribers database to another computer?</p> <p> </p> <p><strong>ANSWER</strong><br><br>Note: This process describes how to proceed if the VSA admin wants to move the SQL server and the database to a new machine, while leaving the Kserver "frontend" on the original machine.</p> <p>Please follow the below process to transfer SQL and the database from one computer to another:</p> <p><br>1) Install SQL using the same collation as the `ksubscribers` database had on your old server. Have the new backend SQL installation fully patched. ForSQL 2005, update this toSP2 installed (minimum). Make sure the system meets system requirements for the appropriate Kaseya version. <br><br>2) Install SQL Management Studio in this new back end db-based machine. See the 'More Information' field below for the Management Studio specific to these respective its SQL version installer.<br><br>3) Create a new ksubscribers backup from the old back end. You can do this by clicking "Backup Now" button in the System > Configure page.<br><br>4) Copy the database backup file to the database server you wish to connect to - Restore this backup to the new back-end. You can do this by using SQL Server Management Studio (SSMS) on the new database server to restore the ksubscribers database. Right click Databases > Restore Databases option.</p> <p>5) Make sure the new backend SQL db-based machine is set to Windows and SQL Authentication. This is also known as 'Mixed-Mode Authentication'.<br><br>6) Now, using the Kaseya VSA, visit the System > Server Management > Configure page.<br><br>7) On this page, click the 'Change DB...' Button.<br><br>8) In the new page, enter the following:<br><br> The IP address/hostname of the new SQL server<br> SA Username - This will be your SA account username<br> Password: This will be your SA account password<br> <br>9) Click on "Apply" - The system will then connect to the new SQL server and as soon as this is done, the system will be back to normal operating status. Refresh the VSA, and re-login.</p> <p><br>10) On the server where Kaseya is installed, search for "Reinstall Database Schema" in the Windows Start menu and select this page to begin this process which will load a browser showing a progress bar running through a number of operations and checks. To double check if the transfer has completed 100%, log back in and visit the System > Server Management > Configure page and scroll all the way down. You should see the IP address or machine name for the new SQL server.</p> <p><br>11) If this is correct, it means that you can turn off the OLD SQL server. Before doing this go to this machine and just STOP SQL service on this OLD server. Verify again if the Kaseya VSA still running.<br><br>If everything is running, the transfer was done with success and the OLD SQL server is history. One can expect the system to be busy after moving the DB, however, as soon as the new SQL server catches up with its assigned tasks, the performance should be back to normal.<br><br></p> <p>------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------</p> <p>NOTE: It has been reported that you may need to restart all your Kaseya services and WWW services (or reboot the server) to complete the process in some cases. </p> <p>NOTE: If you are using SSRS for Reporting, After a restore of a database the SSRS URL may be invalid and need to be reset. Please edit the SSRS URL from the System > Configure page. Click the <strong>Change URL</strong> button to set the new SSRS URL.</p> <p> </p> <p><strong>MORE INFORMATION</strong></p> <p>Download the standard SQL Server Management Studio Express for SQL Server 2005:<br><a href="/home/leaving?allowTrusted=1&target=http%3A%2F%2Fwww.microsoft.com%2FdownloadS%2Fdetails.aspx%3Ffamilyid%3DC243A5AE-4BD1-4E3D-94B8-5A0F62BF7796%26displaylang%3Den" rel="noopener nofollow">http://www.microsoft.com/downloadS/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en</a><br><br>Download the standard SQL Server Management Studio Express for SQL Server 2008:<br><a href="/home/leaving?allowTrusted=1&target=http%3A%2F%2Fwww.microsoft.com%2Fdownloads%2Fdetails.aspx%3Fdisplaylang%3Den%26FamilyID%3D08e52ac2-1d62-45f6-9a4a-4b76a8564a2b" rel="noopener nofollow">http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b</a><br><br><strong>In regards to SQL fine-tuning, make sure to especially look at the memory settings. When allocating memory to SQL, be sure to leave a decent amount of memory (ie.: possibly 25% of memory) to the system for other resources and tasks. </strong>One can do this by right-clicking on the instance name and selecting Properties after running SQL MANAGEMENT STUDIO and connecting to the SQL database. There the option to set MEMORY is present in the right pane.<br><br>Another good option if one is <strong>NOT</strong> running the Express edition is to check the option for AWE on the same page. This will help SQL to manage the memory more efficiently.<br><br></p> <p>For instructions on how to move the Kaseya Database *only* to a new disk partition or Disk drive on the *same* SQL server, see: </p> <p><a rel="nofollow" href="https://kaseya.vanillacommunities.com/kb/articles/aliases/kaseya/entries/32036633-How-to-move-SQL-data-files-to-a-new-partition-or-Disk-drive-on-the-same-SQL-server">https://helpdesk.kaseya.com/entries/32036633-How-to-move-SQL-data-files-to-a-new-partition-or-Disk-drive-on-the-same-SQL-server</a></p> <p> -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------</p> <p><strong>APPLIES TO<br><br></strong>MS SQL Server 2005<br>MS SQL 2005 Express<br>MS SQL Server 2008<br>MS SQL 2008 Express<br>Kaseya v5.1<br>Kaseya v6<br>Kaseya 6.3 and above. </p> </article> </main>