none
SQL jobs fail with: An unexpected error occurred while teh job was running. (ID 104 Details: The device is not ready (0x80070015)) RRS feed

  • Question

  • we have a non-clustered sql server that is not backing up at all to DPM 2010.  We previously thought incremental backups were failing due to another mechanism truncating the logs, so we configured the backups for sync only when doing express full backups.

    We have tried removing the failing db's from the PG and readding, and deleting their replica when doing that.  The backups just say they are inconsistent now, and when we run a consistency check they fail with the error:

    An unexpected error occurred while teh job was running. (ID 104 Details: The device is not ready (0x80070015))

    There are other SQL db's on the sql server, in the same instance that are backing up successfully to the same PG on the same DPM server.

    All of the DBs that are failing to backup are on the same partition on the SQL server.

    We don't know if the problem is with teh source server or the DPM server.

    We verified the collation settings are normal on those dbs (SQL_Latin1_General_CI_AS) and the recovery method is set to Simple, SQL Server 2005 (90)

    Our backup disks have plenty of free space and appear to be healthy.  The disk allocated for these SQL dbs seems plenty adequate as well.

    Thoughts?

    Thanks.




    • Edited by beneb Wednesday, July 11, 2012 7:18 PM
    Wednesday, July 11, 2012 7:17 PM

All replies

  • bttt


    Ben Pahl

    Friday, July 13, 2012 2:27 PM
  • We see in the detailed log: WARNING Failed: Hr: = [0x80070015] : Failed to open volume handle \\?\Volume{xxxx}

    Ben Pahl

    Friday, July 13, 2012 7:51 PM
  • we now suspect this is caused by netapp hardware VSS provider which is installed on the protected server.  the DBs that are failing to backup are on a netapp SAN lun.

    Ben Pahl

    Wednesday, December 5, 2012 10:27 PM
  • Hi,

    Add this registry key to the protected SQL server, This should force VSS to use In-Box VSS Software provider.

    Windows Registry Editor Version 5.00
    [Software\Microsoft\Microsoft Data Protection Manager\Agent\UseSystemSoftwareProvider]

     

     


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Wednesday, December 5, 2012 10:58 PM
    Moderator