Knowledge Base

Knowledge Base
Advanced Search Search the Knowledgebase
 Featured
How to restore back the back up database? (.bak file format)
Author: Microengine Views: 9729 Created: 18-03-2015 03:03 PM 0 Rating/ Voters

This article contains steps to restore the xPortalNet database at the current Server PC using existing backup files (.bak file format).

Applies To:

  • Software xPortalNet v1.5     
 Symptoms
 

› The XPNDB/ XPNTR folder has been deleted from the SQL Server Database.
› From the physical xPortalNet Server folder, the XPNDB.mdb file is deleted/ not exists.

         
 Resolution
 

Caution! Modifying database will affect the software behavior. Only perform this steps if you are familiar with the SQL database otherwise kindly request from your IT Technician for help.

To restore the xPortalNet database, please follow the steps below. Please follow all steps in right order and sequence. 

» This restore database steps also applicable for restore transaction database with .bak file format only.

  1. Make sure the physical xPortalNet Server folder is still exists. The only deleted file is the XPNDB.mdb file only. 
    » If the physical folder is also deleted, please follow the steps to restore database from this article AA-00295.

    Find the physical xPortalNet Server folder from the Server location:


  2. Make sure you have the back up database which is in .bak file format.
  3. Make sure xPortalNet software is not running. Exit the Service, Server and Client completely.
  4. Open SQL Server Management Studio.

  5. The Connect to Server pop up window will be shown. Enter the Login ID and Password. 

    » The Login ID (Instance ID) and Password is created during Microsoft SQL Server 2008 installation. See AA-00290 for the installation step.    

  6. At the top left side menu, find the Databases folder. Right click and select Restore Database.

  7. The Restore Database – XPNDB window will be shown as following. 
    1. Key in XPNDB in the Destination for restore box.
    2. For the Source for restore, select From device then browse the back up database file.


  8. Click Add to browse the back up database file.

  9. Select the location of the back up database file. Click OK.

  10. Please confirm your back up database file location.
  11. Click OK to continue.

  12. Tick the back up sets that you wish to restore.
  13. At the top left of the windows, select Options page.


  14. At the Restore options section, tick the option Overwrite the existing database (WITH REPLACE).
  15. Click OK to start restore the back up database.


  16. You should see this pop-up window when the restore of database is completed. Click OK to finish.

  17. Restore database is completed.
Custom Fields
  • Summary: This article contains steps to restore the xPortalNet database at the current Server PC using existing backup files (.bak file format).
  • Search Tags: restore, xportalnet database, same server pc, default server location
Comments
  • There are no comments for this article.
Submit Feedback on this Article