Securing Data on Machine Not Used Often

• texpic

  SSCertifiable

  Points: 5887

  More actions

  March 15, 2018 at 7:37 pm

  #336570

  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.

• texpic

  SSCertifiable

  Points: 5887

  More actions

  March 15, 2018 at 8:52 pm

  #1983488

  http://www.sqlservercentral.com/scripts/attach+database/96623/

  I found something that works pretty well.