Notification

Icon
Error

Migrate to new server

Posted: Friday, October 16, 2020 5:18:59 AM(UTC)
AdrianP

AdrianP

Member Original PosterPosts: 2
0
Like
Hi All,

I need to move my existing lansweeper server to a new machine.

I'm currently running a localSQL database, and can't find any migration information for that particular database type.

Anyone able to advise of the procedure, or link me to some documentation?

Thanks!
FrankSc
#1FrankSc Member Administration Posts: 74  
posted: 10/16/2020 3:34:30 PM(UTC)
Originally Posted by: AdrianP Go to Quoted Post
Hi All,

I need to move my existing lansweeper server to a new machine.

I'm currently running a localSQL database, and can't find any migration information for that particular database type.

Anyone able to advise of the procedure, or link me to some documentation?

Thanks!


Hello,

If you are referring to a SQL LocalDB, this database can be handled in the same way as a SQL Server database. So you can follow the steps in the KB article mentioned below and follow the steps for SQL server.

https://www.lansweeper.c...per-to-different-server/
AdrianP
#2AdrianP Member Original PosterPosts: 2  
posted: 10/19/2020 6:37:53 AM(UTC)
Originally Posted by: FrankSc Go to Quoted Post
Originally Posted by: AdrianP Go to Quoted Post
Hi All,

I need to move my existing lansweeper server to a new machine.

I'm currently running a localSQL database, and can't find any migration information for that particular database type.

Anyone able to advise of the procedure, or link me to some documentation?

Thanks!


Hello,

If you are referring to a SQL LocalDB, this database can be handled in the same way as a SQL Server database. So you can follow the steps in the KB article mentioned below and follow the steps for SQL server.

https://www.lansweeper.c...per-to-different-server/


Thank you! Though, i am having difficulty running through this process - SSMS is not allowing me to sign in to do the backup. There's only 1 Windows user account on this PC and it was definitely the one that Lansweeper was installed under. Any of the default SQL server authentication methods dont seem to work either.

Im sure i'm missing something obvious here!
MarkPayton
#3MarkPayton Member Posts: 1  
posted: 10/19/2020 4:20:39 PM(UTC)
Originally Posted by: AdrianP Go to Quoted Post
Originally Posted by: FrankSc Go to Quoted Post
Originally Posted by: AdrianP Go to Quoted Post
Hi All,

I need to move my existing lansweeper server to a new machine.

I'm currently running a localSQL database, and can't find any migration information for that particular database type.

Anyone able to advise of the procedure, or link me to some documentation?

Thanks!


Hello,

If you are referring to a SQL LocalDB, this database can be handled in the same way as a SQL Server database. So you can follow the steps in the KB article mentioned below and follow the steps for SQL server.

https://www.lansweeper.c...per-to-different-server/


Thank you! Though, i am having difficulty running through this process - SSMS is not allowing me to sign in to do the backup. There's only 1 Windows user account on this PC and it was definitely the one that Lansweeper was installed under. Any of the default SQL server authentication methods dont seem to work either.

Im sure i'm missing something obvious here!


I had this same thing happen when I tried to move my SQL LocalDB installation to a new server. After confirming via the event log that I was trying the correct account, I tried again and it went through. I am not sure what was different the second (or maybe third) time I tried, but I would give it another go with those credentials.

Active Discussions

Lansweeper Assets with different MACs/IPs getting merged
by  MartinO   Go to last post Go to first unread
Last post: Yesterday at 3:15:25 PM(UTC)
Lansweeper Where is Extension Attribute 1
by  CoolDood  
Go to last post Go to first unread
Last post: 10/22/2020 8:45:46 PM(UTC)
Lansweeper Accessing IMEI/MEID fields for manual assets
by  Tom Londe   Go to last post Go to first unread
Last post: 10/22/2020 5:31:27 PM(UTC)
Lansweeper Server 2019 Version Numbers
by  MCBowman   Go to last post Go to first unread
Last post: 10/22/2020 2:35:32 PM(UTC)
Lansweeper Wake on Lan Issues
by  brodiemac-too  
Go to last post Go to first unread
Last post: 10/21/2020 4:48:10 PM(UTC)