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: 87  
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: 3  
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 Lansweeper Errors - Licencing and scanning
by  dnkleaf   Go to last post Go to first unread
Last post: Yesterday at 1:02:13 PM(UTC)
Lansweeper Search for Blank Fields
by  CS Caritas Socialis IT  
Go to last post Go to first unread
Last post: Yesterday at 12:19:05 PM(UTC)
Lansweeper Uninstalled software still listed
by  Dennis Gewillig   Go to last post Go to first unread
Last post: Yesterday at 9:19:19 AM(UTC)
Lansweeper Software deployment initiated by user
by  LS_enthusiast_4444   Go to last post Go to first unread
Last post: 11/26/2020 9:28:18 PM(UTC)
Lansweeper Help Desk not disabling for regular users?
by  FrankSc  
Go to last post Go to first unread
Last post: 11/26/2020 8:18:38 PM(UTC)
Lansweeper Satisfaction Questionnaire after ticket close
by  mouaad   Go to last post Go to first unread
Last post: 11/26/2020 4:31:44 PM(UTC)
Lansweeper Microsoft EDGE browser support
by  Vapoured  
Go to last post Go to first unread
Last post: 11/26/2020 4:54:30 AM(UTC)