Tools

Recover all deleted Web Help Desk tickets from the SQL Server database

This article describes how to recover all deleted Web Help Desk tickets or cases from a Microsoft SQL Server database using a query.

First published date

11/29/2018 4:07 AM

Last published date

11/29/2018 4:07 AM

Overview

This article describes how to recover deleted Web Help Desk tickets.
 
  • Web Help Desk 12.5.2 and below
  • Microsoft SQL Server database

Product section

Web Help Desk

Resolution

  1. Make sure that you have a current backup of your SQL Server database.

    Always back up your database prior to making any changes. 

  2. Open Microsoft SQL Server Management Studio or another database tool.

  3. Log in to the Microsoft SQL Server Database.

  4. Locate the dbo.JOB_TICKET table.

  5. Execute the following query:

    UPDATE dbo.JOB_TICKET
SET DELETED = 0
WHERE DELETED = 1;