<div>
please refer below article<br />
<br />
<a href="http://support.microsoft.com/kb/314546" rel="ugc">http://support.microsoft.com/kb/314546</a>
</div>


please refer below article

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

<div>
<a href="http://blog.sqlauthority.com/2011/05/27/sql-server-copy-database-from-instance-to-another-instance-copy-paste-in-sql-server/" rel="ugc">http://blog.sqlauthority.com/2011/05/27/sql-server-copy-database-from-instance-to-another-instance-copy-paste-in-sql-server/</a>
</div>


http://blog.sqlauthority.com/2011/05/27/sql-server-copy-database-from-instance-to-another-instance-copy-paste-in-sql-server/ [http://blog.sqlauthority.com/2011/05/27/sql-server-copy-database-from-instance-to-another-instance-copy-paste-in-sql-server/]

<div>
Thank You.<br />
<br />
I will backup and restore.<br />
<br />
Regards<br />
1752
</div>


Thank You.

I will backup and restore.

Regards
1752

<div>
<div class="content wysiwyg-content">
Dear Experts,<br />
<br />
This must be very simple I just want to know the beast way to do it!<br />
<br />
I want to copy the sql 2008 database from my dev PC to my server.<br />
<br />
Both the dev PC and Server have sql 2008.<br />
<br />
What I usually do is detach database copy to the server and attach.<br />
<br />
Regards 1752.
</div>
</div>


Dear Experts,

This must be very simple I just want to know the beast way to do it!

I want to copy the sql 2008 database from my dev PC to my server.

Both the dev PC and Server have sql 2008.

What I usually do is detach database copy to the server and attach.

Regards 1752.

Copying an SQL datatbase

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.