Knowledge Base

› How to detach database from my SQL Server 2008 database?          

Detach database is required before you can delete/ move the xPortalNet database folder from your physical location.
^{Eg: C:\ProgramData\MicroEngine\xPortalNet v1}

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 detach the database, please follow the steps below. Please follow all steps in right order and sequence.  
^{» This detach database steps also applicable for detach transaction database.}

1. Open SQL Server Management Studio.
   


2. 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.     
   
   
3. At the top left side menu, find the Databases folder and click the plus sign to expand the folder.
   


4. 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. 
   
   
5. To detach the database, right click the XPNDB folder. Select Tasks › Detach.
    


6. The Detach Database window will be shown as following.
1. Tick the Drop Connections and Update Statistics box.
2. Click OK to start detach the database.
   
   


7. The window will automatically closed after the database is successfully detached.
8. You should notice that the XPNDB database is no longer exists from the Databases list.
   
   » If you wish to fully delete/ move the xPortalNet database, make sure to detach all databases. (Eg: XPNAudit, XPNDB, XPNTR) 
   
   
9. You may safely delete/ move the database that already detached from the SQL Server Database.