Jeff Byboth

Giving back to the Geek Nation

Thursday, December 11, 2014

SQL Server Stuck in Restoring State

If you database ever gets stuck in restoring state run this script to get it usable again.




RESTORE DATABASE MyDatabaseName WITH RECOVERY
Posted by Unknown at 6:36 AM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)
  • North Wright County Today
  • Simacor
  • Twin Cities Code Camp

Blog Archive

  • ►  2015 (4)
    • ►  March (3)
    • ►  January (1)
  • ▼  2014 (17)
    • ▼  December (2)
      • SQL Server Stuck in Restoring State
      • What is that website built with?
    • ►  November (4)
    • ►  September (1)
    • ►  August (1)
    • ►  July (3)
    • ►  June (1)
    • ►  March (4)
    • ►  February (1)
  • ►  2013 (27)
    • ►  December (1)
    • ►  November (4)
    • ►  October (1)
    • ►  May (2)
    • ►  April (2)
    • ►  March (3)
    • ►  February (6)
    • ►  January (8)
  • ►  2012 (19)
    • ►  November (2)
    • ►  September (4)
    • ►  August (1)
    • ►  July (1)
    • ►  June (1)
    • ►  April (1)
    • ►  March (4)
    • ►  February (5)
  • ►  2011 (1)
    • ►  January (1)
Simple theme. Powered by Blogger.