I have MS SQL Server 2008 available to me. Is it possible to script (perhaps with Powershell?) the processing of all my backup files to drop a table (or two) from each one? I used 7-Zip on the command line to encrypt them so this script will have to be able to handle that.
I'd really like to avoid having to decrypt and then attach each one by hand. That's just not going to cut it but my skills don't afford me the knowledge to know if there's a better.
I'm not asking for a full solution by any means. I'd like to know whether this is actually possible and how someone might go about doing it first.