Re: MSSQL retention for deleted databases

2019-03-12 Thread Hans Christian Riksheim
Thanks Skylar. I noticed it was possible to inactive by running "tdpsqlc inactivate " but the problem from our TSM side is that we don't notice these things and doing regular investigations into this matter is a chore. Wondered if there could be some settings or other tricks to automate this. Reg

Re: MSSQL retention for deleted databases

2019-03-12 Thread Skylar Thompson
A few ways to do it: 1. Run a full incremental backup on the node after the database is removed 2. Use the client-side EXPIRE command with a list of paths to mark inactive 3. If the entire node is going away, use the server-side DECOMMISSION NODE command (take note of the caveats in the documentat

MSSQL retention for deleted databases

2019-03-12 Thread Hans Christian Riksheim
Newbie question(only 18 years of experience with TSM) : How do I ensure that deleted databases get inactivated and expired according to the copygroup settings? As far as I know inactivation of copies >retonly occurs when the database is backed up. If the database is removed all active copies will