Error 4306

Troubleshooting SQL Server

Troubleshooting

Error 4306

Severity Level 16
Message Text

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.

Explanation

After the database has been recovered, no further restore operations may be performed.

Action

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.

See Also

Backing Up and Restoring Databases

RESTORE

Troubleshooting Backing Up and Restoring