Make sure you've selected the correct destination (lansweeperdb) and source for the restore operation. Select Device under Source and browse to the backup file (lansweeperdb.bak) that you previously created. Restore your database backup on your new server by right-clicking the lansweeperdb database in SQL Server Management Studio and selecting Tasks\Restore\Database. This will install a default Lansweeper database in the SQL Server instance specified by you.ĭon't try to manually create the database. Run the Lansweeper installer on your new database server and configure it exactly as shown below. Step 3: install a Lansweeper database under SQL Server In the Options tab, you can tick Verify Backup When Finished to check the integrity of the backup file.Back up to: Disk, add a location where the backup file will be stored.The instance name you need to submit in Management Studio to access your LocalDB database is (localdb)\.\LSInstance and you can access the instance with the Windows user that performed your Lansweeper installation.Ĭreate a backup of your LocalDB database by right-clicking the lansweeperdb database in SQL Server Management Studio and selecting Tasks\Back Up.
If SQL Server Management Studio isn't installed on your Lansweeper server, we recommend downloading it online. Your web server service is either IIS Express or World Wide Web Publishing Service (IIS). Keep in mind that this will log everyone out of the console. Stop your web server service in Windows Services. Stop the Lansweeper Server service in Windows Services. To migrate a Lansweeper database hosted in LocalDB to a SQL Server instance, do the following: Step 1: stop the services You should install SQL Server 2014 or higher, as Lansweeper's LocalDB database server is based on SQL Server 2014. Prior to the migration, make sure to install SQL Server on the machine where the new database will be hosted.
0 kommentar(er)
