SQL Server 2012 copy database failed

I want to make a copy of database in the same SqlServer .
so, When i using the Copy Database Wizard, it throw error:
( I did this steps with a test DB and it works fine !!!!)

config:


sa user


Method:"Use the SQL Management Object method"


Chose new name for destination database.

error:

TITLE: Copy Database Wizard


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


------------------------------ BUTTONS:


OK

in event log :



-
System

• Provider

[ Name] SQLSERVERAGENT

• EventID 208

[ Qualifiers] 16384
Level 3
Task 3
Keywords 0x80000000000000

• TimeCreated

[ SystemTime] 2014-05-07T06:23:11.000000000Z
EventRecordID 123672
Channel Application
Computer Server1
Security

-
EventData


CDW_Server1_Server1_3 0x666DE807F406D7438C65B09171211D7B

Failed 2014-05-07 10:52:50 The job failed. The Job was invoked
by User sa. The last step to run was step 1
(CDW_Server1_Server1_3_Step).


last lines of log file:


OnProgress,Server1,NT
Service\SQLSERVERAGENT,Server1_Server1_Transfer Objects
Task,{066BD090-26F3-45D8-AD60-B207D56D44CE},{1CF7B713-F747-45FB-8936-5522651E0C7A},5/7/2014
10:08:46 AM,5/7/2014 10:08:46 AM,0,0x,Database transfer failed for 1
database(s). OnProgress,Server1,NT
Service\SQLSERVERAGENT,Server1_Server1_Transfer Objects
Task,{066BD090-26F3-45D8-AD60-B207D56D44CE},{1CF7B713-F747-45FB-8936-5522651E0C7A},5/7/2014
10:08:46 AM,5/7/2014 10:08:46 AM,100,0x,Transfer objects finished
execution. OnTaskFailed,Server1,NT
Service\SQLSERVERAGENT,Server1_Server1_Transfer Objects
Task,{066BD090-26F3-45D8-AD60-B207D56D44CE},{1CF7B713-F747-45FB-8936-5522651E0C7A},5/7/2014
10:08:46 AM,5/7/2014 10:08:46 AM,0,0x,(null)
OnPostExecute,Server1,NT
Service\SQLSERVERAGENT,Server1_Server1_Transfer Objects
Task,{066BD090-26F3-45D8-AD60-B207D56D44CE},{1CF7B713-F747-45FB-8936

It might be easier to simply backup the database to a .bak and then create a new database from a .bak restore.

BACKUP DATABASE [aaa] TO DISK = N'E:\aaa.bak'

Then check the logical names and locations for the current files in the .bak:

Restore filelistonly from disk ='E:\aaa.bak'

And finally restore the database, renaming the files to make sure you don't overwrite your existing database

restore database Newdatabasename
FROM disk = 'E:\aaa.bak'
WITH replace,
MOVE 'Logical data name' TO 'E:\Newdatabasename.MDF',
MOVE 'Logical log name' TO 'E:\Newdatabasename.LDF',
recovery --force

StackExchange Database Administrators Q#64630, answer score: 7