
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-15-2010 07:57 PM
We need to move our database from a SQL Server 2000 box to a new server running SQL Server 2005. Are there any additional steps to those listed in the various articles explaining how to move the database?
Labels:
- Labels:
-
Archive
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-16-2010 11:22 AM
# Stop the Lansweeper service.
# Take a full backup of the lansweeper database using the SQL server management studio.
# Do a restore of the database backup and overwrite the Lansweeperdb database on the new server.
# With SQL server management studio recreate the user "Lansweeperuser" and give it the same password as in your web.config file (default: mysecretpassword0*)
# Make the "lansweeperuser" owner of the database "lansweeperdb"
# Edit web.config and lansweeperservice.exe.config to reflect the changes.
# Restart the Lansweeper service on the new server.
# Take a full backup of the lansweeper database using the SQL server management studio.
# Do a restore of the database backup and overwrite the Lansweeperdb database on the new server.
# With SQL server management studio recreate the user "Lansweeperuser" and give it the same password as in your web.config file (default: mysecretpassword0*)
# Make the "lansweeperuser" owner of the database "lansweeperdb"
# Edit web.config and lansweeperservice.exe.config to reflect the changes.
# Restart the Lansweeper service on the new server.
