Bring Database Online after applying all the backups

Backup 1 Minute

If all the backups(full\differential\log) are applied with “NoRecovery” option, the database will be in “Restoring” State and inaccessible to the users and to bring it online and functional – just use “Restore Database DatabaseName”
Syntax : Restore Database UserDB

Published by SQLWhisperer

Hello Everyone. My intention of having this site is to have one repository location for my SQL Server Learning's. Most of the information here is already available on Web but I want to have it in one global location, so I can reference whenever I need . I would be more than happy, if you find anything on this blog useful. Also, Please use your own caution when running any code on your systems.Thank you for visiting.

Published