How to Continue to Backup xPortalNet Software Database if SQL Management Studio Show Error Message of Sector Size

• xPortalNet
• SQL Management Studio

Previously, the customer created a backup file from his personal computer so that he can backup the software settings to the end-user's Server PC. Then, the customer makes additional changes in the end-user's Server PC, and after that, the customer wants to create another backup file to save all the new changes, and is then showed the error message as shown above.

The error message did not allow for the additional backup process to be completed in the end-user's Server PC.

.

.

• To change the backup file path destination for the backup file:

Step 1: Double-click on the SQL Management Studio software icon.

Figure 2: SQL Server Management Studio Icon

.

Step 2: The Connect to Server window will be shown on top of the Microsoft SQL Server Management Studio window. Click Connect to login to the SQL Server Management Studio.

Figure 3: Connect to Server Window

.

Step 3: Once successfully logged into the SQL Server Management Studio, the Object Explorer panel will be shown. Expand the Database folder.

Figure 4: Expanding Database Folder under Object Explorer Panel

.

Step 4: Once the Database folder is expanded, select XPNDB folder under Database folder. Right-click XPNDB > Tasks > Back Up... 

Figure 5: Right-click XPNDB Folder, Selecting Tasks and Back Up

.

Step 5: The Back Up Database - XPNDB window will then be shown. Under the Destination section, select the existing back up file path and click Remove.

Figure 6: Back Up Database - XPNDB Window

.

Step 6: Once the existing file path is removed, click Add to add a new file path for the backup file.

Figure 7: Add a new Backup File Path

.

Step 7: The Select Backup Destination window will be shown. Keep the file path as default and click OK to save the changes.

Figure 8: Select Backup Destination Window

.

Step 8: Users can now proceed to backup the XPNDB database as usual.