" The job failed" in copying database SQL Server 2012

Question

I'm trying to copy a database. When going through the Copy Database Wizard, I'm getting a Execute SQL Server Agent Job error. The error states

The job failed. Check the event log on the destination server for details

Performing operation

• Add log for package (Success)

• Add task for transferring database objects (Success)

• Create package (Success)

• Start SQL Server Agent Job (Success)

• Execute SQL Server Agent Job (Error)

Error:

The job failed. Check the event log on the destination server for details. (Copy Database Wizard)

I can't seem to find what causing this problem. Am I using the correct approach? I just need to copy this database. Thanks in advance.

Answer 1

if you are trying to Clone your database on the same server try this:

1. Create a backup of the database you want to copy
2. right-click on Databases and select Restore Database
3. Select the database you want to copy from the From Database drop-down list in the Source for restore section
4. Enter the name of the new database in the To database field in the Destination for Restore section - this cannot be the name of an existing database.
5. Click OK