CODEWITHSUNDEEP
sql-serversql-server-2012
Adil Malik
Adil Malik

Reputation: 6357

SQL Server 2012 cannot copy Database

I am working with SQL server 2012. I want to copy a database along with all the data. I just want to create a dev DB.

I know SQL Server 2012 has a Copy Database... wizard. But when I run that wizard, I get an error on the last step:

enter image description here

On error, it tells me that error log in inside a text file on the shown path. When I go to that path, there is no such file there.

Can anyone please help me with this?

Upvotes: 0

Views: 1030

Answers (3)

Ben Thul
Ben Thul

Reputation: 32707

The file path is relative to the server. This is because the copy database wizard (CDW) creates a SQL Agent job to do the work. The file is the execution log for the agent job.

Upvotes: 0

Adil Malik
Adil Malik

Reputation: 6357

I had to do it the other way. I created an empty DB and used import wizard to import all the data and the schemas. This worked without any error. But I still don't know why the Copy Wizard didn't work.

Upvotes: 1

Amir Keshavarz
Amir Keshavarz

Reputation: 3108

Check event log, If you use Backup and Restore mode, change it to detach and attach mode.

Upvotes: 0

Related Questions