Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2015-02-02
6
Medium Priority
?
196 Views
Last Modified: 2015-02-11
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
Comment
Question by:cismoney
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 17

Expert Comment

by:max_the_king
ID: 40586156
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
 

Author Comment

by:cismoney
ID: 40586980
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
 
LVL 17

Accepted Solution

by:
max_the_king earned 2000 total points
ID: 40587500
Hi,
Then you should include the mgmt class in either The option file or cloptset

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

Max
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

Author Comment

by:cismoney
ID: 40588187
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
 
LVL 17

Expert Comment

by:max_the_king
ID: 40593165
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
 

Author Closing Comment

by:cismoney
ID: 40602673
thanx a lot max the king
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to update Firmware and Bios in Dell Equalogic PS6000 Arrays and Hard Disks firmware update.
Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

718 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question