Knowledge Base

› How to back up xPortalNet database?          

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 back up the xPortalNet database, please follow the steps below. Please follow all steps in right sequence order.

» This back up database steps also applicable for back up transaction database.

1. Make sure xPortalNet software is not running. 
2. Please ensure that the Service, Server and Client already closed.
3. Run the SQL Server Management Studio.
       


4. The Connect to Server pop up window will be shown. Enter the Login ID and Password. Then click Connect.
   
   › The Login ID ^{(Instance ID)} and Password is created during Microsoft SQL Server 2008 installation. See AA-00290 for the installation step.     
   
   
5. At the top left side menu, find the Databases folder and click the plus sign to expand the folder.
   


6. You should found the 'XPNDB' and 'XPNTR' folder after expanding the Databases folder.
   
   » You may notice that the list of XPNTR folder shown is different. The Transaction database is according to your transaction pull up at the software. 


7. To back up the database, right click the 'XPNDB' folder. Select 'Tasks' and then select 'Back Up'.
   


8. The 'Back Up Database – XPNDB' window will be shown as following. 
9. Click 'Remove' to remove default back up destination folder location.
    
   
10. Please make sure that you have selected Back up to: 'Disk'.
11. Click 'Add' to add a new back up destination folder location.
    
    


12. Browse the destinations on disk for back up destination folder location.
    


13. Select the location that you preferred to locate the back up database. 
14. For this example, the back up destination folder location is at ^{C:\ProgramData\MicroEngine\xPortalNet v1}
15. Set the File name to "XPNDB.bak" and then click OK.
    
    » Please remember back up destination folder location.
    
    
16. Please confirm your back up destination folder location.
17. Click OK to continue.
    


18. Click OK to start back up the database.
    
    


19. You should see this pop-up window when the database back up is completed. Click OK to finish.
    


20. Go to the back up destination folder location to view the file.
    


21. Back up database is completed.