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
  • Product Sunsets Non-Supported Products
Barcode System Consult
Barcode Printer Consult
Barcode Label Consult
  • Portal
  • Knowledgebase
  • Discontinued Products
  • MobileAsset
  • MobileAsset: How to Restore the Database from MDF and LDF Files
Subscribe Download PDF

MobileAsset: How to Restore the Database from MDF and LDF Files

Nathaniel Summers
2023-01-19
in MobileAsset

Issue: In most cases, one should use the Backup, Move, and Restore procedure found in the following:
https://support.waspbarcode.com/kb/articles/154

In instances where a backup cannot be made the following method may allow you to restore using the MDF and LDF data files.


1. Locate the Original MDF and LDF files

The location of your database files should be located in:
C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.WASPDBEXPRESS\MSSQL\DATA\
The exact location may be different depending upon your version of SQL and/or operating system
You're looking specifically for the following files:
WaspTrackAsset.mdf
WaspTrackAsset_log.ldf

Copy these files to the new PC


2. Install MobileAsset on the New Machine

Fully install MobileAsset on the new machine
Be sure to select Database, Service, and Client tools during the installation
We should be able to open MobileAsset to see a blank slate when completed


3. Stop the Services

On the PC where new database is to reside, open your services list:
Click Start > Run (or Windows Key + R) to open the Run Dialog

Type Services.msc
click OK

Find and stop the following services:
Wasp MobileAsset Windows Service
SQL Server (WASPDBEXPRESS)

MA-RestoreFromMDF-001-StoppingServices.jpg


4. Copy out the current MDF and LDF files

In the following location:
C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.WASPDBEXPRESS\MSSQL\DATA\

Copy the following files to a different location
WaspTrackAsset.mdf
WaspTrackAsset_log.ldf

(This is so we have something to go back to if the restore is not successful)


5. Copy the Original MDF and LDF files over the new files

Take the original MDF and LDF files, and copy them to the location of the new files.
If prompted to replace the files, select yes


6. Start SQL Server (WASPDBEXPRESS) Service

The SQL Server (WASPDBEXPRESS) Service was previously stopped, start it again.

Do not start the other service yet.

MA-RestoreFromMDF-002-StartInstanceService.jpg


7. Fix Restored Users

Log into SQL Server Management Studio using SQL Authentication and the following credentials
Username: sa
Password: Wasp$07Wasp$07

Click File menu > Open > File

Navigate to:
C:\Program Files (x86)\Wasp Technologies\MobileAsset\Database\WaspDBInstaller\Upgrade\ 

And open the file
FixAssetUser.sql 

With the WaspTrackAsset database selected in the dropdown, click Execute

MA-RestoreFromMDF-003-FixUsers.jpg


8. Restart Wasp MobileAsset Windows Service

MA-RestoreFromMDF-004-StartWMWS.jpg

You should now be able to open MobileAsset and see all your old data.

Rate the quality of this page

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

33 of 55 people found this page helpful


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