What if I restored a database with “NO RECOVERY” option
keeping in mind that I’d keep continuing with another Differential backup set /
Transactional backup set next. But then I’ve decided not to proceed further?
At this moment, database is in “Restoring” state and
inaccesible.
I need to run following script bringing a database back from restoring
state to normal.
RESTORE DATABASE
WITH RECOVERY
No comments:
Post a Comment