How to Verify xPortalNet Database Backup Useability

Summary:

• To check whether a xPortalNet database backup can be read and restored.

.

Step-by-step Guide:

• To check whether a xPortalNet database backup can be read and restored:

Step 1: Launch the SQL Server Management Studio.

.

Step 2: The Connect to Server window will be shown, click Connect to continue.
 
Figure 1: Connect to Server Window

.

Step 3: The Microsoft SQL Server Management Studio window will be shown. Click on New Query to connect.
 
Figure 2: New Query in Microsoft SQL Server Management Studio Window

.

 
Figure 3: Enlarged View of the New Query Button

.

Step 4: Use the following syntax to check whether a database backup can be read and restored.
 
Figure 4: Syntax to Check Whether Database Backup can be Read and Restored

.

.

.

Step 5: Type RESTORE VERIFYONLY to test a database backup, Execute the following.
 
Figure 5: Executing the Syntax in SQLQuery Window

.

  
Figure 6: Complete Syntax Example

.

Step 6: If the backup is valid, the SQL Server Database Engine returns the following message and indicate The backup set on file 1 is valid.

Figure 7: The Backup Set on File 1 is Valid