title: Should I back up an SQL database to file or another DB?
body: <p>I want to run a daily back up of an SQL database. I was thinking I would do this to another DB (primarily to act as a safeguard against my own mistakes or user errors), but all the scripts that I've found do it to a file.</p>
  
  <p>Is it advisable to backup to another database, and if the data's stored as a file on the server, won't having unencrypted data there create a security risk? Is there a good encryption method, should it all be encrypted in the DB? Is there a good script out there for doing this?</p>
  
  <p>Any help would be much appreciated!</p>
  
  <p>Ben</p>