Home
  •  

Backup Volume Size Insufficient

Microsoft.SQLServerAppliance.BI.BackupVolumeSizeInsufficientRule (Rule)

The size of the backup volume (E:) is not enough to backup drives C:, D:, and the hidden volume “System”.

Knowledge Base article:

Summary

Content of drives C:, D: and hidden volume “System” is too large to be stored to backup volume during the next backup job.

Causes

The backup job which is available from Appliance Web Console stores all content of drives C:, D: and hidden volume “System” to volume E:. Volume E: has a limited capacity and there is potentially not enough room to complete a backup because of a large amount of data on the drive D:.

Resolutions

If size of the backup volume E: is not enough to store the backup data anymore then check that you have no obsolete files on drives C: and D:. Delete these files and resolve this alert.

The appliance onboard backup is only meant to be an interim solution. You should investigate off appliance backup options.

Element properties:

TargetMicrosoft.SQLServerAppliance.BI.Server
CategoryAlert
EnabledTrue
Alert GenerateTrue
Alert SeverityWarning
Alert PriorityNormal
RemotableTrue
Alert Message
Backup Volume Size Insufficient
The backup volume size on Appliance Server "{0}" is insufficient.

Member Modules:

ID Module Type TypeId RunAs 
DS DataSource Microsoft.SQLServerAppliance.BI.VolumesState.DataSource Default
BackupVolumeSizeInsufficient ConditionDetection System.ExpressionFilter Default
GenerateAlert WriteAction System.Health.GenerateAlert Default

Source Code:

<Rule ID="Microsoft.SQLServerAppliance.BI.BackupVolumeSizeInsufficientRule" Target="BIDisco!Microsoft.SQLServerAppliance.BI.Server" Enabled="true" Remotable="true">

  <Category>Alert</Category>

  <DataSources>

    <DataSource ID="DS" TypeID="Microsoft.SQLServerAppliance.BI.VolumesState.DataSource">

      <IntervalSeconds>900</IntervalSeconds>

      <TargetComputerName>$Target/Property[Type="Windows!Microsoft.Windows.Computer"]/PrincipalName$</TargetComputerName>

      <TimeoutSeconds>300</TimeoutSeconds>

    </DataSource>

  </DataSources>

  <ConditionDetection ID="BackupVolumeSizeInsufficient" TypeID="System!System.ExpressionFilter">

    <Expression>

      <SimpleExpression>

        <ValueExpression>

          <XPathQuery Type="String">//Property[@Name='BackupVolumeSizeInsufficient']</XPathQuery>

        </ValueExpression>

        <Operator>Equal</Operator>

        <ValueExpression>

          <Value Type="String">true</Value>

        </ValueExpression>

      </SimpleExpression>

    </Expression>

  </ConditionDetection>

  <WriteActions>

    <WriteAction ID="GenerateAlert" TypeID="Health!System.Health.GenerateAlert">

      <Priority>1</Priority>

      <Severity>1</Severity>

      <AlertMessageId>$MPElement[Name="Microsoft.SQLServerAppliance.BI.BackupVolumeSizeInsufficientRule.AlertMessage"]$</AlertMessageId>

      <AlertParameters>

        <AlertParameter1>$Target/Property[Type="Windows!Microsoft.Windows.Computer"]/PrincipalName$</AlertParameter1>

      </AlertParameters>

      <Suppression>

        <SuppressionValue>$Target/Property[Type="Windows!Microsoft.Windows.Computer"]/PrincipalName$</SuppressionValue>

      </Suppression>

    </WriteAction>

  </WriteActions>

</Rule>