question

jonlellelid avatar image
jonlellelid asked

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
copy-databaseservice-accountjob failure
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

I am using SQL Server 2014.
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.