Warning! Users are not recommended to run any xPortal software in Windows XP operating system as the system is unstable Users are also advised to stop the xPortal Services before shutting down the Server PC to prevent any missing transaction issues.
. . Summary Note Detaching xPortalNet database is required in order to delete / move the physical xPortalNet database. Default location of physical xPortalNet database: C: Program Data\MicroEngine\xPortalNet v1.
Step-by-step Guide:
Step 1: To close xPortalNet Server & Client if any of the software instances are still running.
Step 2: Right-click the xPortalNet Service icon, click Stop. Wait for the pop-up message indicating that the xPortalNet Service has been stopped.
Figure 1: Right-click xPortalNet Service Icon and click Stop
Figure 2: xPortalNet Service Stopped Pop-up Message
Step 3: Open SQL Server Management Studio on desktop.
Figure 3: SQL Server Management Studio Icon
Step 4: The Connect to Server window will be shown. Click Connect to continue.
Figure 4: Connect to Server Window
Note If Authentication is done under SQL Server Authentication, please key-in the User Name and Password before clicking Connect. The User Name and Password is created during Microsoft SQL Server 2012 installation. Please refer to How to Install Microsoft SQL Server 2012 for the installation step.
Step 5: Under the Object Explorer window, expand the Databases folder.
Figure 5: Databases Folder under the Object Explorer Window
Step 6: A drop down list of components inside the Databases folder will be shown as below. The XPNDB and XPNTR components will be visible after expanding the Databases folder.
Figure 6: Components inside the Databases Folder
Note The list of XPNTR folder may be slightly different for different users. The transaction database is structured based on the monthly transactions pulled up by the software.
Step 7: To detach the XPNDB component, right-click the XPNDB > Tasks > Detach.
Figure 7: To Detach XPNDB Component
Step 8: The Detach Database window will be shown. Check both Drop Connections and Update Statistics checkboxes and click OK to continue.
Figure 8: Detach Database Window
Step 9: The window will automatically be closed after the selected database is successfully detached.
Step 10: The XPNDB database will no longer be shown in the Databases folder.
Figure 9: The XPNDB Component is No Longer Shown
Step 11: To completely delete / move the xPortalNet database, repeat steps 7 to 9 to detach all remaining databases such as XPNDB, XPNTR, and XPNAudit.
Step 12: Users may safely delete / move the physical databases after detaching the databases from the SQL Server Database.
|