Unusual Backup Error in SQL Server

You might be wondering what is happening in your SQL Server when you see the error message given below. Its all simple, you need not panic.

Error Number: 18272
Error Message: I/O error on backup or restore restart-checkpoint file ‘%1’. Operating system error %2. The statement is proceeding but is non-restartable.

This happens when SQL server is not able to find the default backup directory. SQL Server needs to create a checkpoint file when a BACKUP or RESTORE operation happens. This happens when the RESTART option is specified. WITH RESTART tells SQL Server to start from the point where the operation was last aborted. When SQL Server searches for the file and its not available then this error is thrown.

How to avoid this error:

  1. Check the default backup directory for the SQL Server and see if exists, if not create it.
  2. Verify if the backup directory has enough space in it.
  3. Verify if SQL Server service account has permissions to read and write into that directory

Leave a Reply

Leave a comment

Your email address will not be published. Required fields are marked *



Related Posts

Issues restoring SQL Azure bacpac due to QueryStoreStaleQueryThreshold
In our environment we have inhouse and SQL Azure databases. We will be refreshing the DEV environments weekly once from the production SQL Azure ...
Backup Report
I was working on one the project and they were looking for a backup report which should specify whether it's physical or logical and few more det...
SQL 2012 DTA Engine Crashes on Windows 8
Question: Some time back I wrote an article on the new feature that’s added to SQL Server 2012 DTA (database tuning advisor). I have installed S...
powered by RelatedPosts