Previous Next JavaScript must be enabled to correctly display this content

## Verify Restored Data

This section explains how you can verify that you have successfully restored the data from the backup.

Start the SQL shell on storage node 3:

    java -Xmx64m -Xms64m -jar lib/sql.jar -helper-hosts phoenix581601:5000 -store mystore -security kvroot2/security/client.security
    Login as:root
    root's password:<password>

SQL prompt is displayed

    sql->

Enter command to show the tables

    show tables

Output:

    tables
      SYS$IndexStatsLease
      SYS$MRTableAgentStat
      SYS$MRTableInfo
      SYS$MRTableInitCheckpoint
      SYS$PartitionStatsLease
      SYS$SGAttributesTable
      SYS$StreamRequest
      SYS$StreamResponse
      SYS$TableMetadata
      SYS$TableStatsIndex
      SYS$TableStatsPartition
      SYS$TopologyHistory
      ticket

Read the data in table ticket.

    select * from ticket

Output:

    {"ticketNo":34567890,"confNo":"DFGRTH"}
    {"ticketNo":12345678,"confNo":"LEJDFG"}
    {"ticketNo":45367892,"confNo":"FGRTFB"}

    3 rows returned

You can see that the metadata, tables and data that you had backed up are now restored and available on the new store.