Copy Database Wizard Failure in SQL Agent Job

I am attempting to make a copy of a database on the same server as an archive(size constraints). I have enough space on another drive on the same server in which I created a folder. I used the SQL Management Object method. It failed! I have included showing the steps I took and the SQL Agent Failure log. I looked at the Copy Database Wizard documentation: https://docs.microsoft.com/en-us/sql/relational-databases/databases/use-the-copy-database-wizard

See attachments.

The job runs for a brief moment; I saw the database name created on the alternate drive. On failure the database disappears.

Is this a permission issue?

In the “schedule the package dialog box is lists the Integration Services Proxy Account as SQL Server Agent Service Account… is this just the default, yet it does not really exist? Where would I find the SQL Server Agent Service Account if it does exist? Do I need to create a Proxy account?

Have you other recommendations other than Copy Database Wizard?

[1]: /storage/temp/4089-cdw-ils-test01-polaristransactionsarchive-agent-jo.log

more ▼

asked May 16, 2017 at 02:30 PM in Default

avatar image

81 7 9 13

I am using SQL Server 2014.

May 16, 2017 at 02:38 PM jonlellelid
(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: May 16, 2017 at 02:30 PM

Seen: 88 times

Last Updated: May 18, 2017 at 01:31 PM

Copyright 2018 Redgate Software. Privacy Policy