<div>
It is better to create a backup of your exisitng database and restore it on the new server 
</div>


It is better to create a backup of your exisitng database and restore it on the new server

<div>
<div class="content wysiwyg-content">
expert: I am not a db type but I have a working database on one MS SQL 2005 Server and someone created a similar but blank database on another MS SQL 2005 Server. I want to know how to go about copying my existing database tables over to the blank database on the other &nbsp;MS SQL 2005 Server and perhaps also the data?
</div>
</div>


expert: I am not a db type but I have a working database on one MS SQL 2005 Server and someone created a similar but blank database on another MS SQL 2005 Server. I want to know how to go about copying my existing database tables over to the blank database on the other  MS SQL 2005 Server and perhaps also the data?

how to copy a MS SQL 2005 Server database to another  MS SQL 2005 Server

Microsoft SQL Server 2005 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. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.