Page Comparison

Summary

• To detach xPortalNet database from SQL Server.

Step-by-step Guide:

• To detach xPortalNet database from SQL Server:

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.
Image Modified
Figure 1: Right-click xPortalNet Service Icon and click Stop

Image Modified
Figure 2: xPortalNet Service Stopped Pop-up Message

Step 3: Open SQL Server Management Studio on desktop.
Image Modified
Figure 3: SQL Server Management Studio Icon

Step 4: The Connect to Server window will be shown. Click Connect to continue.
Image Modified
Figure 4: Connect to Server Window

Step 5: Under the Object Explorer window, expand the Databases folder.
Image Modified
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.
Image Modified
Figure 6: Components inside the Databases Folder

Step 7: To detach the XPNDB component, right-click the XPNDB > Tasks > Detach.
Image Modified
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.
Image Modified
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.
Image Modified
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.