title: SQL Server 2000 / SQL Server Management Studio 2008 - How to copy a database?
body: <p>I'm connecting to a SQL Server 2000 server with SQL Server Management Studio 2008 and need to make a copy of a database. </p>
  
  <p>Right-Click the database and pick Copy Database brings up the nice wizard. When I pick the destination server (the <em>same</em> server as the source server) the wizard happily tells me I need SQL Server 2005 or better and stops.</p>
  
  <p>How can I make a copy of the database? I have no access to the computer other than through the management studio. Upgrading the server is not an option that is available to me.</p>