This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Community FAQ
Register | Log In
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Lansweeper Community
- Forums
- General Discussions
- Re: sql server restore failed to new server
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Register to ask a question, start a topic or share an idea
Join the Community
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-18-2011 12:35 AM
Hi Admin,
I had an old server on which i had installed lansweeper and now I have a new box where I would like to install. I installed all correctly, now when I try to restore the database from the old server to the new I get this error as shown in the attached picture.
What I did is click on tasks in management studio and create a backup of the old database and then on the new server click on tasks and then restore. I am doing by logging on to the management studio as "sa".
Please advice.
Thanks,
Moss
I had an old server on which i had installed lansweeper and now I have a new box where I would like to install. I installed all correctly, now when I try to restore the database from the old server to the new I get this error as shown in the attached picture.
What I did is click on tasks in management studio and create a backup of the old database and then on the new server click on tasks and then restore. I am doing by logging on to the management studio as "sa".
Please advice.
Thanks,
Moss
Solved! Go to Solution.
Labels:
- Labels:
-
General Discussion
1 ACCEPTED SOLUTION
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-04-2011 10:27 AM
I ended up rescanning the whole database from scratch. Stiwa I have not tried your solution. But I may try it out on another test server and see if it works.
I had lost few details but it was not that many. I still have the database so I can manually copy those details.
Thanks,
Moss
I had lost few details but it was not that many. I still have the database so I can manually copy those details.
Thanks,
Moss
5 REPLIES 5
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-04-2011 10:27 AM
I ended up rescanning the whole database from scratch. Stiwa I have not tried your solution. But I may try it out on another test server and see if it works.
I had lost few details but it was not that many. I still have the database so I can manually copy those details.
Thanks,
Moss
I had lost few details but it was not that many. I still have the database so I can manually copy those details.
Thanks,
Moss
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-25-2011 12:44 PM
I have recently moved lansweeper to another server and had some problems restoring the database.
So i deleted the new db (created from setup) and then restored it from backup.
After that you have to delete the lansweeperuser from your lansweeperdb users and associate new as db_owner from global lansweeperuser useraccount.
So i deleted the new db (created from setup) and then restored it from backup.
After that you have to delete the lansweeperuser from your lansweeperdb users and associate new as db_owner from global lansweeperuser useraccount.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-23-2011 11:30 AM
Hi Admin,
Unfortunately that did not work either. I was able to actually create a new blank database in management studio and then do a restore. Now my problem is how do I copy all the data from the blank new database to the one on which lansweeper has been installed.
Any help would be appreciated.
Kind Regards,
Moss
Unfortunately that did not work either. I was able to actually create a new blank database in management studio and then do a restore. Now my problem is how do I copy all the data from the blank new database to the one on which lansweeper has been installed.
Any help would be appreciated.
Kind Regards,
Moss
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-23-2011 05:39 PM
moss wrote:
Hi Admin,
Unfortunately that did not work either. I was able to actually create a new blank database in management studio and then do a restore. Now my problem is how do I copy all the data from the blank new database to the one on which lansweeper has been installed.
Any help would be appreciated.
Kind Regards,
Moss
This will be hard, you need to create your own import sql scripts.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-18-2011 09:02 AM
There is a checkbox you can check in the options "force restore over existing database"
General Discussions
Find answers to technical questions about Lansweeper.
New to Lansweeper?
Try Lansweeper For Free
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now
Related Content
