Verify Database Partition

The following steps will help you to verify the status of Enabling/Disabling of partition.

To verify the enabled partition status

1. Open SQL Server Management Studio.

2. Select the Database of AVEVA Data source.

3. Right-click the Menu and select Properties option.

   When the partition is enabled, you will see the following items in the Database Properties of the system:

   • The ARCHIVED file in Files page

   • The ARCHIVED scheme in Filegroups page

   • File with <DataSource Name _ARC.ndf> under the secondary selected folder path

To verify the disabled or removed partition status

4. Open SQL Server Management Studio.

5. Select the Database of Work Tasks Data source.

6. Right-click the Menu and select Properties option.

   When the partition is disabled or removed, you will not see the following items in the Database Properties of the system:

   • The ARCHIVED file in Files page

   • The ARCHIVED scheme in Filegroups page

7. After disabling partition, run the following query and see if the file still exist in the database:

   SELECT * FROM sys.master_files WHERE name = '<DatabaseName>_ARC'

   If the file still exists, take a transaction log backup before you proceed to enable partition.