Securing Data on Machine Not Used Often

  • texpic

    SSCertifiable

    Points: 5880

    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: 5880

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

    I found something that works pretty well.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply