Navigate
Wasp Helpdesk
  • Register

  • or
  • Login
    Need a password reminder?
or
Contact Us
  • Get in touch

    Send us an email

  • Start a chat session

  • Knowledgebase Read help articles
  • News News & updates
  • Contact Us We are here to help
  • Training View our options
  • Portal
  • Knowledgebase
  • Cloud
  • Cloud On-Premise: How to backup and restore the database
Subscribe Download PDF

Cloud On-Premise: How to backup and restore the database

Sicaro Burnett
2023-02-02
in Cloud

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.1595970502680.png
  • Login using Windows Authentication1595970572557.png
  • Once in SSMS you will expand Databases.  In there you will see two databases that need to be backed up,  WaspAuth and WaspTrack.  

1596726491070.png

  • Right-click the  database you need to backup and select Tasks, then choose Back Up.

1595970663688.png

  • Next to the lower Destination section of the Back Up Database -  click Remove to remove anything currently shown in the box. 

1595970869401.png

  • 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.

1595970921788.png

1595970717080.png

1595970782165.png

1595970995015.png


1595971044304.png

1595971072335.png

 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.

1596726730339.png



 2. Restore the backup on the new server 

  • Log into SQL.  Click on Start > Programs > Microsoft SQL Server > SQL Server Management Studio.

1596036979459.png

  • Login using Windows Authentication

1596037027402.png

  • Expand Databases on the left and right click on WaspAuth > go to Tasks > Restore > Database.. 

1595971507243.png

  • Select the 'From device' option and click on the browse (...) button

1596037134894.png

  •  Click on the 'Add' button 

1596037181078.png

  • This should open up to the correct backup folder containing your database backup and select the file > click on OK > click on OK.

1596037230923.png

1596037259107.png

1596037353609.png

  • In the lower 'Select the backup sets to restore' section of the Restore Database window, check the box next to the database set displayed. 1596037402759.png
  • 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

1596732025189.png


  • 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

1596727265944.png


  • Choose Save As

1596727419520.png

Remember where you saved the file (the Desktop is easy to find)

1596727463567.png

1596727506257.png


  • Once the file has been downloaded, switch back to SQL Server Management Studio and choose File menu > Open > File

1596732226590.png

  • Choose Desktop (or the location you saved the file to)

1596732289485.png

  • Once the script is loaded, Execute should have a green arrow next to it in the toolbar.

1596727765240.png

  • Click on Execute 
  • You should see Completed at the bottom of the screen when it has finished.  



Rate the quality of this page

This page was helpful :) :( This page was not helpful

Related Pages

  • Cloud On-Premise: Moving the database to a different SQL server (V2)
  • Cloud On-Premise: Moving the database to a different SQL server
  • Cloud On-Premise installation: Summary & Prerequisites

Quick Jump
  • Wasp Helpdesk
  • Knowledgebase
  • News
  • Contact Us
Top
Helpdesk software provided by Deskpro