This article describes how to create and restore a Wasp OnPremise (AssetCloud OnPrem or InventoryCloud OnPrem) backup with SQL Server Management Studio.
Follow these steps to move and restore the database to a new server.
Note: Install AssetCloud or InventoryCloud On Prem software on new Server prior to performing the steps below. Ensure you are able to login. If needed, see the article linked below in Related Pages: Cloud On-Premise installation: Summary & Prerequisites.
1. Create a backup of the existing database.
- Log into SQL. Click on the Windows Logo> Microsoft SQL Server > SQL Server Management Studio.
- Login using Windows Authentication
- Once in SSMS you will expand Databases. In there you will see two databases that need to be backed up, WaspAuth and WaspTrack.
- Right-click the database you need to backup and select Tasks, then choose Back Up.
- Next to the lower Destination section of the Back Up Database - click Remove to remove anything currently shown in the box.
- Click Add. It will display the folder path for the installation. At the end of the path, add a filename for the backup that will be unique, like ServerMove.bak. Click OK on both windows to create the backup.
Make note of the Backup location.
- Transfer the two files to the destination server, via flash drive, network copy, or other method to transfer the backup files to the new server. On the new server, open Windows Explorer and copy the backup files to C:\Program Files\Microsoft SQL Server\MSSQL14.WASPDATA\MSSQL\Backup.
Note: It is important to copy the files to the Backup folder to ensure they receive the correct permissions so SQL can read them.
2. Restore the backup on the new server
- Log into SQL. Click on Start > Programs > Microsoft SQL Server > SQL Server Management Studio.
- Login using Windows Authentication
- Expand Databases on the left and right click on WaspAuth > go to Tasks > Restore > Database..
- Select the 'From device' option and click on the browse (...) button
- Click on the 'Add' button
- This should open up to the correct backup folder containing your database backup and select the file > click on OK > click on OK.
- In the lower 'Select the backup sets to restore' section of the Restore Database window, check the box next to the database set displayed.
- Click on 'Options' on the left of the window and check the box that says 'Overwrite the existing database' Note: If Tail-Log backup is checked, uncheck this box
- Finally click on OK at the bottom and the backup should start restoring.
- After the progress bar on the left reaches 100% the restore should be complete.
Repeat the restore steps for the WaspTrack database.
Leave SQL Server Management Studio open.
- After restoring both database backups, copy the link below and paste into your browsers address bar and press Enter This will download the following .sql script
https://dl.waspbarcode.com/kb/op/RestoreOPDatabaseUserAccounts.sql
- Choose Save As
Remember where you saved the file (the Desktop is easy to find)
- Once the file has been downloaded, switch back to SQL Server Management Studio and choose File menu > Open > File
- Choose Desktop (or the location you saved the file to)
- Once the script is loaded, Execute should have a green arrow next to it in the toolbar.
- Click on Execute
- You should see Completed at the bottom of the screen when it has finished.