If you are restoring a database using multiple backup files, you
would use the WITH NORECOVERY option for each restore except the last. If your database is still in the restoring state and you want to
recover it without restoring additional backups you can issue a RESTORE
DATABASE .. WITH RECOVERY to bring the database online for users to use.
Here is the syntax.
Here is the syntax.
RESTORE DATABASE
<DATABASE_NAME>
WITH RECOVERY
No comments:
Post a Comment