This error occurs because the BACKUP or RESTORE process needs to create a checkpoint file that will indicate at what point any failure occurs. This allows the WITH RESTART option to be used under some circumstances. The WITH RESTART option specifies that SQL Server should restart a restore operation that has been interrupted. The information about how much data the BACKUP or RESTORE command had processed before the interruption occurred is stored in a checkpoint file in the BACKUP directory in the SQL Server installation directory.
Some of the reasons the checkpoint file cannot be created could include:
The BACKUP directory does not exist under the directory where SQL Server is installed. For instance, this directory is not automatically created for MSDE instances, or the directory may have been removed.
The drive where the BACKUP directory resides is full.
The BACKUP directory is not accessible to the SQL Server startup account.
Verify that the BACKUP directory exists under the directory where SQL Server is installed. If it does not exist, create it.
Verify that there is available space on the drive where the BACKUP directory resides.
Verify that the SQL Server startup account has permission to read from and write to the BACKUP directory.
| Target | Microsoft.SQLServer.2000.DBEngine | ||
| Category | EventCollection | ||
| Enabled | True | ||
| Event Source | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | ||
| Alert Generate | True | ||
| Alert Severity | Warning | ||
| Alert Priority | Normal | ||
| Remotable | True | ||
| Alert Message |
| ||
| Event Log | Application | ||
| Comment | Mom2005ID='{0384B0DF-10CA-4EA4-987A-C0EFF785FE83}' |
| ID | Module Type | TypeId | RunAs |
|---|---|---|---|
| EventDS | DataSource | Microsoft.Windows.EventProvider | Default |
| GenerateAlert | WriteAction | System.Health.GenerateAlert | Default |
Home<Rule ID="Microsoft.SQLServer.2000.I_O_error_on_backup_or_restore_restart_checkpoint_file" Target="SQL2000Core!Microsoft.SQLServer.2000.DBEngine" Enabled="true" Comment="Mom2005ID='{0384B0DF-10CA-4EA4-987A-C0EFF785FE83}'" Remotable="true">
<Category>EventCollection</Category>
<DataSources>
<DataSource ID="EventDS" TypeID="Windows!Microsoft.Windows.EventProvider">
<ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>
<LogName>Application</LogName>
<Expression>
<And>
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery>PublisherName</XPathQuery>
</ValueExpression>
<Operator>Equal</Operator>
<ValueExpression>
<Value>$Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
<Expression>
<RegExExpression>
<ValueExpression>
<XPathQuery>EventDisplayNumber</XPathQuery>
</ValueExpression>
<Operator>MatchesMOM2005RegularExpression</Operator>
<Pattern>^(17052|17055)$</Pattern>
</RegExExpression>
</Expression>
<Expression>
<RegExExpression>
<ValueExpression>
<XPathQuery>EventDescription</XPathQuery>
</ValueExpression>
<Operator>MatchesMOM2005BooleanRegularExpression</Operator>
<Pattern>(^.*18272 and (not ^.*\n.*18272)) or (^.*18272.*\n.*18272)</Pattern>
</RegExExpression>
</Expression>
</And>
</Expression>
</DataSource>
</DataSources>
<WriteActions>
<WriteAction ID="GenerateAlert" TypeID="SystemHealth!System.Health.GenerateAlert">
<Priority>1</Priority>
<Severity>1</Severity>
<AlertOwner>$Data/PublisherName$</AlertOwner>
<AlertMessageId>$MPElement[Name="Microsoft.SQLServer.2000.I_O_error_on_backup_or_restore_restart_checkpoint_file.AlertMessage"]$</AlertMessageId>
<AlertParameters>
<AlertParameter1>$Data/EventDescription$</AlertParameter1>
</AlertParameters>
<Suppression>
<SuppressionValue/>
</Suppression>
</WriteAction>
</WriteActions>
</Rule>