none
Move protected SQL Server DB storage RRS feed

  • Question

  • I have a SQL Server Enteprise 2005 DB on which I moved some of the DB data files from one drive to another, for capacity reasons. Nothing else changed. This server is being protected by DPM 2012 SP1. The DB backups were working fine until I moved the storage. I immediately started getting consistency errors that could not be resolved. I removed the DB's from the protection group, and checked 'Delete replica on disk', and then added them back. These DB's will still not back up, giving the error below. Other DB's on this server are still being successfully backed up (full backup daily with incrementals every four hours). What can I do to resolve this error?

    Type:    Consistency check
    Status:    Failed
    Description:    DPM failed to communicate with the protection agent on {SQL Server} because the agent is not responding. (ID 43 Details: Internal error code: 0x8099090E)
        More information
    End time:    9/15/2015 5:00:26 PM
    Start time:    9/15/2015 4:48:46 PM
    Time elapsed:    00:11:39
    Data transferred:    0 MB
    Cluster node    {SQL Server}
    Source details:    {SQL Server}\{DB}
    Protection group:    SQL Daily 9pm Full - Every 4 Hours Logs
    Items scanned:    0
    Items fixed:    0

    Tuesday, September 15, 2015 10:13 PM