title: SQL Server: how do I export entire database?
body: <p>I need to export database from one server and import it into another server.</p>
  
  <ol>
  <li>How do I export the entire database to a file, or two files mdf, ldf (either option is fine)</li>
  <li>How do I import it into a new server using ssms?</li>
  </ol>
  
  <p>In the instructinos frmo ponies, it says:</p>
  
  <blockquote>
    <p>In the To a point in time text box,
    either retain the default (Most recent
    possible) or select a specific date
    and time by clicking the browse
    button, which opens the Point in Time
    Restore dialog box. For more
    information, see How to: Restore to a
    Point in Time (SQL Server Management
    Studio).</p>
    
    <p>To specify the source and location of the backup sets to restore, click
    one of the following options:</p>
  
  <pre><code>From database
  
  Enter a database name in the list box.
  </code></pre>
  </blockquote>
  
  <p>I am unable to type anything in restore</p>
  
  <p><a href="https://stackoverflow.com/questions/3241108/i-backed-up-the-database-in-ssms-sql-server-how-do-i-restore-it">https://stackoverflow.com/questions/3241108/i-backed-up-the-database-in-ssms-sql-server-how-do-i-restore-it</a></p>