I have a computer that I infrequently use for development. It has about 20 databases and 40 gigs of MDF/LDF (simple recovery if that is important). For the most part, any confidential info doesn't live on that machine but there are a few tables that have client names, addresses and phone.
I have a query that will backup all the databases at once; so I can backup and zip them with a password. I then would need to delete (is this best) all the databases at once; then a query to restore all the bak files at once.
If there is a better way, I'd appreciate it. Thanks.