Error 4306
Collapse the table of content
Expand the table of content

Error 4306

SQL Server 2000

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.


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.

See Also

Backing Up and Restoring Databases


Troubleshooting Backing Up and Restoring

© 2015 Microsoft