Submit a ticketCall us

WebinarWebinar: A checklist for planning your Network Performance Monitor (NPM) upgrade

Are you ready for your next upgrade? To help you plan smoothly, join this webcast to learn more about, SolarWinds® Orion® Installer, SolarWinds Upgrade Advisor, Upgrades Guides, Training Videos, and other resources available. We’ll share key upgrade planning considerations, lessons learned from customers with practical advice from SolarWinds Product Experts. We’ll also give practical tips to identify the estimated time needed and resources, how to prepare the business and IT staff for changes, ways to plan for required system changes, and more.

Register now.

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