Follow

How do I move SQL and the Ksubscribers database to another computer?

KB#:  KKB000706

QUESTION

How do I move SQL and the Ksubscribers database to another computer?

 

ANSWER

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.

Please follow the below process to transfer SQL and the database from one computer to another:


1) Have the new backend SQL installation fully patched. ForSQL 2005, update this toSP2 installed (minimum). Makes sure the system meets system requirements for the appropriate Kaseya version. 

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.

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.

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.

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'.

6) Now, using the Kaseya VSA, visit the System > Server Management > Configure page.

7) On this page, click the 'Change DB...' Button.

8) In the new page, enter the following:

     The IP address/hostname to the new SQL server
     SA Username - This will be your SA account username
     Password: This will be your SA account password
   
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-log in.


10)  Return to the Configure page and click the Reapply Schema link near the top of the page. Wait for it to complete. To double check if the transfer has completed 100%, 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.


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 in this OLD server. Verify again if the Kaseya VSA still running.

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 withits assigned tasks, the performance should be back to normal.

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

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. 

 

MORE INFORMATION

Download the standard SQL Server Management Studio Express for SQL Server 2005:
http://www.microsoft.com/downloadS/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

Download the standard SQL Server Management Studio Express for SQL Server 2008:
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b

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.  One can do this by right clicking in the instance name and selecting Properties after running SQL MANAGEMENT STUDIO and connecting with the SQL database. There the option to set MEMORY is present in the right pane.

Another good option if one is NOT running the Express edition is to check the option for AWE in the same page. This will help SQL to manage the memory more efficiently.

For instructions on how to move the Kaseya Database *only* to a new disk partition or Disk drive on the *same* SQL server, see: 

https://helpdesk.kaseya.com/entries/32036633-How-to-move-SQL-data-files-to-a-new-partition-or-Disk-drive-on-the-same-SQL-server

 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

APPLIES TO

MS SQL Server 2005
MS SQL 2005 Express
MS SQL Server 2008
MS SQL 2008 Express
Kaseya v5.1
Kaseya v6
Kaseya 6.3 and above. 

Was this article helpful?
2 out of 2 found this helpful
Have more questions? Submit a request

0 Comments

Article is closed for comments.