Why does open file backup fail with error 800423f4?

Why does open file backup fail with error 800423f4?

Previous Top Next

This error can be caused by the SQL Server (MSDE) volume shadow copy writer when the SQL Server database recovery model is not set to simple.

To resolve this error, please change your SQL Server database recovery model to simple. Data Protection automatically performs incremental backups, so the more complicated recovery models should not be used, as they interfere with the backup process and create redundant data. Please see here and here for more information.

Procedure to change the database recovery model to simple:

1. Start SQL Server Enterprise Manager.

2. Navigate to each database that you are backing up.

3. Right-click each database and choose Properties.

4. Click the Options tab.

5. Under Recovery, set the model to Simple.

This error can also be caused when the SQL Server (or MSDE) startup service is running under a startup account with the format .\UserName.

To resolve this error, configure the startup account of the SQL Server service to use the LocalSystem account. Alternatively, use a fully qualified user name: Domain\UserName. Please see here for more information.

Procedure to change the startup account of the SQL Server service:

1. Start the Services task within Administrative Tasks. Alternatively, run services.msc

2. Locate the MSSQLSERVER service in the list.

3. Right click on the service and choose Properties.

4. Click the Log On tab.

5. Change Log on as to be the Local System account. Alternatively, click This account and specify an account located within a domain.