<div>
One more link if you wish to use tsql sp_attach and sp_detach syntaces.<br />
<br />
<a href="http://support.microsoft.com/kb/224071" rel="ugc">http://support.microsoft.com/kb/224071</a><br />
<br />

</div>


One more link if you wish to use tsql sp_attach and sp_detach syntaces.

http://support.microsoft.com/kb/224071 [http://support.microsoft.com/kb/224071]



<div>
Thanks. &nbsp;Does this not just move the database? &nbsp;How do you make just a copy of the database? &nbsp;<br />
<br />
Thanks,<br />
<br />
Dan
</div>


Thanks.  Does this not just move the database?  How do you make just a copy of the database?  

Thanks,

Dan

<div>
You can backup and restore to the other server, or alternatively, you could use the Copy Database wizard.
</div>


You can backup and restore to the other server, or alternatively, you could use the Copy Database wizard.

<div>
Okay, yes I will use the copy database wizard
</div>


Okay, yes I will use the copy database wizard

<div>
if you want to move only tables and views you can use export and import option for moving the objects<br />
<br />
this also one option. 
</div>


if you want to move only tables and views you can use export and import option for moving the objects

this also one option.

<div>
<div class="content wysiwyg-content">
How do you copy a SQL Server Database from one location to another using Microsoft SQL Server 2008?<br />
<br />
Thanks,<br />
<br />
Dan
</div>
</div>


How do you copy a SQL Server Database from one location to another using Microsoft SQL Server 2008?

Thanks,

Dan

How Do You Copy a MS SQL Database ?

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.