Warning AW51007

Wait for processing of restored has timed out. However, the database restore may still be successful.

Module

Agent for Microsoft SQL Server

Reason:

When a database or transaction log is restored, Microsoft SQL Server requires additional processing of the data that has been restored before it can bring the database online or accept restore of additional differential or transaction log backups for the database. If the session restored is a large transaction log, this can take a long period of time, and in this case it has taken longer than the timeout that has been set to wait for this processing (3 hours by default).

Action:

If the session being restored was the last session to be restored to this database, no further action is required, though you may want to increase the timeout period for this wait. If additional sessions need to be restored to this database, you must wait for this processing to complete, and then either package a new restore job containing only the remaining sessions, or increase this timeout period and re-run the job.

To package only the remaining sessions, you will need to disable Automatic Dependency Selection to do this, but it will save time.