The preceding restore operation did not specify WITH NORECOVERY or WITH STANDBY. Restart the restore sequence, specifying WITH NORECOVERY or WITH STANDBY for all but the final step.
After the database has been recovered, no further restore operations may be performed.
To recover a database, start the sequence over and use the NORECOVERY clause on all RESTORE statements except the last. If you are maintaining a standby server and want to bring up the database in read-only mode between restore operations, use the STANDBY clause of RESTORE instead of the NORECOVERY clause.
| Backing Up and Restoring Databases | RESTORE |
| Errors 4000-4999 | Troubleshooting Backing Up and Restoring |