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 Webcam report, the wrong way
by  TimHolmes1973   Go to last post Go to first unread
Last post: Yesterday at 4:38:45 PM(UTC)
Lansweeper zerologin posted report
by  hanslepire  
Go to last post Go to first unread
Last post: Yesterday at 8:50:59 AM(UTC)
Lansweeper Need help finishing a report for Failed Logons
by  Helpdesk15   Go to last post Go to first unread
Last post: 10/20/2020 3:10:33 PM(UTC)
Report Center Chart: Microsoft Office 365 Versions
by  craigsmith.lpi  
Go to last post Go to first unread
Last post: 10/19/2020 10:18:21 PM(UTC)
Lansweeper Russian in Report
by  EStarshinov   Go to last post Go to first unread
Last post: 10/15/2020 7:18:22 AM(UTC)
Lansweeper Asset location report with count ?
by  Argon0  
Go to last post Go to first unread
Last post: 10/14/2020 11:05:33 AM(UTC)
Lansweeper Inventory for all Connected Headphone
by  Csteenhaut   Go to last post Go to first unread
Last post: 10/8/2020 1:45:25 PM(UTC)
Lansweeper All Ticket Overview Report
by  Ryan211  
Go to last post Go to first unread
Last post: 10/6/2020 11:27:33 PM(UTC)