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. :-)
Saturday, 25 May 2013
Wednesday, 15 May 2013
SQL Server 2012: OFFSET-FETCH
Hello all and welcome back (finally!) to SQL Something. :-)
Been a while I know, but sometimes life steps in your way a
little bit. But hey even in those times, life teaches you something new.
Recently I’ve studying for the Microsoft 70-461 Exam
(Querying Microsoft SQL Server 2012) so if you find posts in the future seem to
be query related then you know why. :-p
A lot of the stuff I’m reading so far seems interchangeable with
stuff you can use in SQL Server 2008 queries but I did run into something early
that seemed kind of interesting. That thing is OFFSET-FETCH.
Subscribe to:
Posts (Atom)