DB move to SQL Cluster

[chads]

Looking for the instructions or feedback from any user on how to move the LS DB running on SQL 2012 Express to Full Blown SQL Cluster. Please keep in mind your current instructions cannot be applied as nothing gets installed on the SQL cluster. So is there a way to take the backup of the current DB and Restore it into the SQL Cluster and Tell the current LS server to go look for the DB there?

[Daniel_B]

You can simply perform a new install on your existing server. Choose the option to install a new database on SQL Server. On the next page in the installer enter the hostname\instancename of your SQL Server.

[chads]

So on the current Lansweeper server run the installer again? or do we have to remove LS first? of course doing the DB backup.

[Daniel_B · Accepted solution]

You need to

• take a backup of your current database, as explained in this KB article
  
• perform a new installation of Lansweeper in advanced install mode, choose SQL Server as database and connect to your SQL Server cluster. Either run the installer under an account which has sysadmin permissions on your SQL Server or choose SQL Server authentication
  
• restore your database backup onto the new database

This KB article provides aggregated instructions on how to move your database to a different server.

Note: You don't need to run the installer directly on the database server. It is enough to provide the SQL Server hostname\instance name during the installation process.