title: Backup remote SQL Server database to local
body: <p>I'm trying to backup a live database to my computer and I can't find the option to do it. I'm connecting to it using Microsoft SQL Server Management Studio 2008 R2. I'm a MySQL monkey, so I'm used to being able to backup to <code>.sql</code> files and move them around.</p>
  
  <p>Anyone have any idea how I can create a file backup of the database? I've found the backup option which only backs up on the server, or the export, which seems to only allow a single table, or code an SQL query, which I'm not too sure on, short of putting in something like <code>SHOW TABLES;</code></p>
  
  <p>Anyone have any ideas? I'm limited to readonly access for various reasons, nothing bad, promise!</p>