none
Replica is inconsistent with sql database

    Question

  • I'm receiving the following errors when trying to backup a specific SQL database on a remote server, using DPM 2010:

    Affected area: SERVERNAME\SharePoint_Config
    Occurred since: 2/1/2013 1:23:16 PM
    Description: The replica of SQL Server 2008 database SERVERNAME\SharePoint_Config on SERVERNAME.mwellp.com is inconsistent with the protected data source. All protection activities for data source will fail until the replica is synchronized with consistency check. You can recover data from existing recovery points, but new recovery points cannot be created until the replica is consistent.

    For SharePoint farm, recovery points will continue getting created with the databases that are consistent. To backup inconsistent databases, run a consistency check on the farm. (ID 3106)
     DPM failed to synchronize changes for SQL Server 2008 database SERVERNAME\SharePoint_Config on SERVERNAME.mwellp.com because the snapshot volume did not have sufficient storage space to hold the churn on the protected computer (ID 30115 Details: VssError:Insufficient storage available to create either the shadow copy storage file or other shadow copy data.
     (0x8004231F))
     More information
    Recommended action: Retry the operation at a later point when the churn is expected to be lower.
     Synchronize with consistency check.
     Run a synchronization job with consistency check...
    Resolution: To dismiss the alert, click below
     Inactivate

    When I run the vssadmin list shadowstorage, I get this on the volume hosting the data:

    Shadow Copy Storage association
       For volume: (C:\Program Files\Microsoft System Center 2012\DPM\DPM\Volumes\Re
    plica\SqlServerWriter\vol_95e61c5e-59e2-4ed8-91a5-39c1b5cd5b7b\)\\?\Volume{a1a43
    b94-6a5e-11e2-81a9-00215ad798a8}\
       Shadow Copy Storage volume: (C:\Program Files\Microsoft System Center 2012\DP
    M\DPM\Volumes\DiffArea\SqlServerWriter\vol_95e61c5e-59e2-4ed8-91a5-39c1b5cd5b7b\
    )\\?\Volume{a1a43b9a-6a5e-11e2-81a9-00215ad798a8}\
       Used Shadow Copy Storage space: 0 B (0%)
       Allocated Shadow Copy Storage space: 0 B (0%)
       Maximum Shadow Copy Storage space: UNBOUNDED (100%)

    It is not part of a sharepoint farm, just single stand alone machine.  The machine itself doesn't have much free space available, was wondering if that could be the issue or not.  The DPM server has plenty of space available for backups.  Thanks.


    Randy Oster

    Friday, February 01, 2013 6:46 PM

Answers

  • Hi,

    The lack of disk space will be on the SQL server, please check shadowcopy storage configuration and free space there.   Dpm does not make a shadow copy on the DPM server until after initial replication which does not appear to have completed yet.


    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.

    Saturday, February 02, 2013 1:44 AM