Submit a ticketCall us

Bridging the ITSM Divide
Integrated help desk and remote support software for faster resolution

Join us on Wednesday, November 29, 2017 at 11 a.m. CT, as we discuss the benefits of effectively integrating your help desk software with remote support solutions to help increase the efficiency of IT administration, improve communication, and decrease mean time to resolution (MTTR) for IT issues of all sizes. This directly impacts end-user satisfaction and your business’ bottom line. Register Now.

Home > Success Center > Patch Manager > Patch: How to Backup and Restore Scheduled tasks

Patch: How to Backup and Restore Scheduled tasks

Updated: October 16, 2017

Overview

This article shows you how to back up and restore scheduled tasks.

Environment

  • Patch 2.0 +

Steps

How to back up scheduled tasks

1. Make a backup of C:\Program Files\SolarWinds\Patch Manager\Server\scheduled.

2. Open MSSQL Studio and navigate to the EminentWare database.

3. Create a new Table (default name dbo.Table_1).

4. Under the tables folder find the dbo.ewbatchtask table.

5. Make a copy of this table in any way you feel comfortable.

For example: 

USE EminentWare

INSERT INTO dbo.Table_1

SELECT * FROM dbo.ewbatchtasks

6. Back up the database and keep it offline.

How to restore scheduled tasks

1. Restore the database table.

USE EminentWare

SELECT * FROM dbo.Table_1

INSERT INTO dbo.ewbatchtasks

2. Restore the scheduled folder to C:\Program Files\SolarWinds\Patch Manager\Server\scheduled.

3. Open Patch Manager.

 

Last modified

Tags

Classifications

Public