Device Not Ready

• Steve-0

  SSChasing Mays

  Points: 600

  More actions

  November 27, 2013 at 11:18 am

  #286871

  Hey everyone,

  I realize that people have posted with regards to this error before as the search brought up a couple however, none of them seem to correlate with the issue that I am currently experiencing.

  I am able to run each step of a batch file that contains steps to dump/copy/load.

  I am NOT able to get this same batch to work through SQL Server Agent. The job completes however it gives the following error.

  "The device is not ready. Process Exit Code 21. "

  I confirmed that the database is completing all steps successfully. I have verified the data files, the data itself, and have confirmed it's clear of error after running DBCC check.

  Any thoughts on this would be greatly appreciated.

  As always, thanks in advance for your help!

  Steve

• Sreekanth B

  SSCertifiable

  Points: 6145

  More actions

  November 27, 2013 at 11:55 am

  #1669547

  Look at this if it helps...

  http://social.msdn.microsoft.com/forums/sqlserver/en-US/d5d8a5fa-a9be-4998-ad23-ec8b03cf19dc/the-device-is-not-ready-error-when-executing-package-on-the-server

• Steve-0

  SSChasing Mays

  Points: 600

  More actions

  November 27, 2013 at 12:50 pm

  #1669563

  That resolution was chalked up to be a network issue. Credentials are as they are on the DRP server and it works fine on that side. I have confirmed all pathing in the batch file is referenced based on it's destination, local vs network.

  Any thoughts?

  Steve