SQL2008 error handling during copy database

The first method:

When you perform a database copy, the "Start-to-Job cdw_hl-20130526slgg_hl-20130526slgg_1" failure occurs when you use it normally. (Copy Database Wizard), correct how to: Start SQL Server Agent first, if there is an original error in the agent's job, it needs to be deleted first, and then run;

The second method (GO):

SQL Server 2005/2008 copies the tables in one database to another database in full! (Resolved)

1. Copy the table [Oa_email] from the database "OA" to the Database "Q", which requires the first step:

Right-click Edit Table Script->create to the new Query editing window, copy the content!

2. Then, in the query, select Database "Q", right-click on "New Query", then paste in the code copied above.

Remember to remove the use OA line code and select Execute.

This time, the table has come out, but only the structure.

3, in the database "Q", has added a table [Oa_email], but no data, need to take a step:

(1) Import data in database "Q", right-click-to-task, import the table.

(2) Note: Select Source table Original view, click Edit Map, select Enable identity insertion, OK, next

In this case, the data import success, the steps seem complex, in fact, very simple.

SQL2008 error handling during copy database