Skip to content

Instantly share code, notes, and snippets.

@sayham-sjb

sayham-sjb/RemoveRestoringStateFromDB.sql

Last active February 12, 2019 00:44
Show Gist options
  • Save sayham-sjb/23e74f583283673ef3252688dc21c7cf to your computer and use it in GitHub Desktop.
Save sayham-sjb/23e74f583283673ef3252688dc21c7cf to your computer and use it in GitHub Desktop.
Download ZIP
RemoveRestoringStateFromDB #sql
Raw
RemoveRestoringStateFromDB.sql
--The following command will take a database that is in the "restoring" state
--and make it available for end users.
--If the DB is awaiting a log restore that could result in considerable data loss
RESTORE DATABASE {DB Name} WITH RECOVERY
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment