Hey guys, just a quick post here on how to take your database out 'RESTORING' state.
So maybe you stopped Mirroring, maybe you were restoring transaction logs, maybe your database has an issue and curled up into itself or maybe you accidently restored a DB with the "WITH NORECOVERY" option (or heck, maybe you did it on purpose).
The bottom line is your DB is currently in restoring.
To remove it from this state, please run the following:
RESTORE DATABASE YourDBName WITH RECOVERY
Ta-da! Its back online. :-)
DISCLAIMER: As stated, I’m not an expert so please, PLEASE feel free to
politely correct or comment as you see fit. Your feedback is always
welcomed. :-)
No comments:
Post a Comment