Submit a ticketCall us

whitepaperYour VM Perplexities Called, and They Need You to Read This.

Virtualization can give you enormous flexibility with future workloads and can be a key enabler for other areas, like cloud computing and disaster recovery. So, how can you get a handle on the performance challenges in your virtual environment and manage deployments without erasing the potential upside? Learn the four key areas you need to be focusing on to help deliver a healthy and well-performing data center.

Get your free white paper.

Home > Success Center > Web Help Desk (WHD) > WHD - Knowledgebase Articles > Recover all deleted Web Help Desk tickets from the SQL Server database

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

Updated August 9, 2018

Overview

This article describes how to recover deleted Web Help Desk tickets.

Environment

  • Web Help Desk 12.5.2 and below
  • Microsoft SQL Server database

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. If you'd like to use SolarWinds Backup, click here for information. You can try it out for free.

  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;
    

     

Last modified

Tags

Classifications

Public