Troubleshooting
      Back to home
      1. Knowledge Base
      2. Lumi ViewPoint
      3. Troubleshooting

      Retrieving deleted Lumi TVT messages

      Learn how to find a deleted TVT message in the SQL database.

      When using Lumi Text-Vote-Talk you may accidentally deleted a message but do not fear, we can go into the SQL database and pull the information from the relevant table.

      Note::

      You require SQL Server Management Studio and SQL Express installed in order to view the database tables. LocalDB is not capable.

      1. Open SQL Server Management Studio
      2. Click Connect
      3. Expand Databases
      4. Find your database i.e, Iml_YourDb
      5. Expand Tables
      6. Scroll down to text.Message
      7. Right click and click Select Top 1000 Rows
      8. On the right hand-side you will see a SQL Script and beneath it your messages. Find the IsDeletedcolumn and any with a 1 will be your deleted messages
      9. Right click in the table and select Save Results As, type a name and a CSV will be created
      10. You can test live to see when you delete a message and then refresh the server

      SQL

      Note:

      We can also retrieve a poll

      Lumi ViewPoint dark

      Reviewed and Approved by Product Team