• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 204
  • Last Modified:

IBM Tivoli TSM (for sql server) : how to set up management class for differential backups

Hello experts,

I use tdp for sql to backup one of our most important database.

We have applied management policy for the full backups , but unfortunately we don't see the option to apply policies to the differential backups, can you please help?

I also want to know how to delete manually differential backups

differential backup
0
cismoney
Asked:
cismoney
  • 3
  • 3
1 Solution
 
max_the_kingCommented:
Hi,
although my french is not good, i see from your screenshot that you're trying to configure differential backups by means of VSS method, whereas that is possible only with LEGACY method.
Should you want to restore a differential version already saved, you first need to restore the last full you have performed  and then apply the differential version (point in time) you need. Please remember that you just need to restore one differential file, since it is cumulative of all last version until the last full backup.
hope this helps
max
0
 
cismoneyAuthor Commented:
hello max the king.

I  am not trying to do a restore.

I actually want to assign a management class to the differential backups.

A management class is already assigned to the full backup but I am not able to do it for the differential backup.
0
 
max_the_kingCommented:
Hi,
Then you should include the mgmt class in either The option file or cloptset

INCLUDE "\...\data\...\diff*" <mgmtclass_diff>

Max
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
cismoneyAuthor Commented:
Thanx a lot Max the King,

Can you please help me a little bit , it seems that I don't have the right syntax on my option file.

The sql server name is NSA-NP-SQLDB\NSASQLDB
The name of the Database is AGR_GUINEE
The name of the management class is  DIFF_GUINEE_MGMT
0
 
max_the_kingCommented:
Hi,
whatever your database and sql server names are, you just need to include the management class you created:

INCLUDE "\...\data\...\diff*" DIFF_GUINEE_MGMT

you need to put that line into the opt file you associated with tdpsql, e.g. into the TDPSql directory.
After restarting the client it should be linked to that management class

hope this helps
max
0
 
cismoneyAuthor Commented:
thanx a lot max the king
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now