Knowledge Base

Knowledge Base
Advanced Search Search the Knowledgebase
How to detach xPortalNet database from my SQL Server 2008 database?
Author: Microengine Views: 6234 Created: 19-03-2015 02:11 PM 0 Rating/ Voters

This article contains steps to detach database from the SQL Server 2008 database. 

Applies To:

  • Software xPortalNet v1.5
 Problem
 

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

         
 Resolution
 

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.
Custom Fields
  • Summary: This article contains steps to detach database from the SQL Server 2008 database.
  • Search Tags: detach, xportalnet database, sql server
Comments
  • There are no comments for this article.
Submit Feedback on this Article