Knowledge Base

Log Shipping error 130 when moving restored file

Category: Troubleshooting & error messages
Date: 17 Mar 2011
Product: SQL Backup
Cause:

The path specified for the MOVETO keyword is the same location as the network share.

Explanation:

When the restore job successfully applies the log backup file, the log backup file is then moved from the network share to another folder or directory, as set by the MOVETO parameter. This action is designed to prevent the already restored log file from interfering with the subsequent log restore task.

In the above scenario, the user has configured the MOVETO parameter to use the same disk path or folder location as the network share. When this occurs, SQL Backup issues a warning exit code 130 to indicate a failure to move the restored log backup file.
Subsequent log restore tasks will issue SQL Backup warning code 470 to indicate that the log backup file has already been restored. The process also generates two SQL server exit codes: 4326 (to inform that the Log Sequence Number (LSN) is out of sequence and the backup file being applied is too early to apply) and 3013 (a generic error code to inform that the task is terminating abnormally).

Edit the Log Restore Job so that the restored log files are moved to a different folder. To edit the restore job, you will need to do this via SSMS -> SQL Server Agent -> Jobs -> Select the Job -> Right-click and select Properties. In the job properties dialog box, under "Select a Page", click on steps "Edit the step". Look for the MOVETO keyword and change the path to point to a different folder path and not to be the network share UNC path or the network share local disk path.