Pages

Friday, February 4, 2011

SQL Database stats Shutdown,Normal

If you got your "database status is shutdown, normal mode".
Run the below query for reset the database status to Normal mode.

ALTER DATABASE <yourDB> SET AUTO_CLOSE OFF

Now the database should be Normal mode.