This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 74%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
I am trying to copy an existing database to a new database with a different name to use in testing. However, every time I use the Copy wizard it fails and tells me to look in the server event log but that log tells me nothing about why it failed. It only says that the agent job failed and a warning like "SQL Server Scheduled Job 'CDW_LIFEDEV2012_LIFEDEV2012_3' (0x5C0DAFD8B0D3A44993E5A4467BCB2CCF) - Status: Failed - Invoked on: 2020-10-12 08:46:20 - Message: The job failed. The Job was invoked by User SERVER1\David. The last step to run was step 1 (CDW_LIFEDEV2012_LIFEDEV2012_3_Step)."
Hi,
This error provide nothing. It is only information about the JOB and not the source of the issue.
(1) Are you trying to copy database on SQL Server on premises to another Database on premises or are you speaking about Azure? If this is a database in SQL Server and you want to copy it to another instance then why not backup the database and restore it?
(2) What wizard are you using?!? Can you please elaborate more. It seems like you use SQL Server Agent JOB, but what the JOB is executing?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 30%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETH%3C/text%3E%3C/svg%3E)
David is using the Copy Database Wizard.
You know the sound Sideshow Bob does when stepping on a rake which hits him in the face? Yeah, that wizard. :-)
I suggest using BACKUP and RESTORE instead. This way you don't have so spend hours trying to troubleshoot and hunt down the relevant error messages (probably permissions related, the service account for the agent server not having appropriate permissions on the source server).