” The job failed” in copying database SQL Server 2012

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