File ‘‘ cannot be restored to ‘‘. Use WITH MOVE to identify a valid location for the file.

HRESULT 0x80131501 received during a restore operation If Wait for Tape Mounts for File Information option is not selected on the Restore Database or Restore Groups/Files panel of the Data Protection for SQL GUI, a Legacy restore operation might fail with the following error message: File ‘<name>’ cannot be restored to ‘<file name>’. Use WITH…

Read More

Collection of useful TSM scripts

Scripts Code CLIENTEVENTS – Desc=”Display number of client events per state in a specific date. $1 = YYYY-MM-DD” SELECT DATE(scheduled_start) as DATE, status, count(*) as number_events FROM events WHERE DATE(scheduled_start)=’$1′ and node_name is not null GROUP BY DATE(scheduled_start), status COMPARESTGPOOLS – Desc=”Compare amount of space and number of files between two stgpools. $1 – stgpool_1…

Read More

Restore Data using the command line

How to enter to TSM client: root@um~# dsmc How to check where are the configuration files (usually is /usr/tivoli/tsm/client/ba/bin): root@um~# echo $DSM_DIR How to check when last backup ran: root@um~# dsmc q fi How to check schedule (use -se if you want to check it for a specific server): root@um~# dsmc q sched root@um~# dsmc…

Read More

TSM LAN FREE Backup Configuration

1) TSM Storage Agent for client with same level fix according to the TSM server 2) TSM server Side Configuration 3) Tape library device driver’s installation on client side for sharing library 4) Environment considerations for LAN free Backup 5) TSM storage Agent Configuration on client side 6) TSM storage Agent Initialization Steps: 1) Server…

Read More