title: Backup SQL Server database
body: <p>I can connect to remote SQL Server database and I want to create a local database copy on my system. How can  I do it? When i try backup through Management studio I cannot copy backup file on my hard drive only on remote system hard drive. Copy database command also doesn't work because I have express version of SQL Server. And export command doesn't transfer stored procedures, only tables data. Any suggestion?</p>
  
  <p>Does T-SQL BACKUP command can help me? if it does then how to use that command?</p>
  
  <p>I havn't access to remote computer. Only mssql connection.</p>