Delete legacy backup - FMY5170E ?

vilius.m

ADSM.ORG Senior Member
Joined
Jul 23, 2008
Messages
76
Reaction score
4
Points
0
TSM: 7.1.10
MSSQL client: all versions I tried

I'm trying to delete legacy mssql backup:
> tdpsqlc delete backup model full /tsmoptfile=dsm.opt /configfile=tdpsql.cfg
FMY5170E Missing, blank, or invalid Local DSMAGENT Node Name is not allowed.

> type dsm.opt
COMMMethod tcpip
TCPPort 1500
TCPServeraddress x.x.x.x
NODename node1
PASSWORDAccess generate
ERRORLOGName "C:\Program Files\Tivoli\TSM\TDPSql\dsmerror.log"
SCHEDLOGName "C:\Program Files\Tivoli\TSM\TDPSql\dsmsched.log"
ERRORLOGRetention 30
SCHEDLOGRetention 30
USEREPLICATIONFailover no
FORCEFAILOVER no
NRTABLEPath "C:\Program Files\Tivoli\TSM\TDPSql"

INCLUDE "\...\meta\...\diff*" mmssqldiff
INCLUDE "\...\data\...\diff*" mmssqldiff
INCLUDE "\...\meta\...\log*" mmssqllog
INCLUDE "\...\data\...\log*" mmssqllog

> type tdpsql.cfg
LASTPRUNEDate 04/24/2020 01:11:21
SQLSERVer xxxx
FROMSQLserver xxxx
SQLAUTHentication INTegrated
MOUNTWaitfordata Yes
BACKUPMethod LEGACY
DIFFESTimate 20
BUFFers 3
BUFFERSIze 1024
STRIPes 1
SQLBUFFers 0
SQLBUFFERSIze 1024
LOGFile C:\Progra~1\Tivoli\TSM\TDPSql\tdpsql.log
LOGPrune 60
LANGuage ENU

I never used any DSMAGENT parameters cause I use legacy mode.
How do I delete certain backup ?

Thanks,
Vilius M.
 
I just noticed that delete command is for VSS only:
Use the delete backup command to delete a VSS backup of an SQL Server
database.
I needed to delete few small backups in order to move them to other management class.
If someone knows a way to delete legacy backup other than policy please share.
 
Back
Top