Welcome

Passionately curious about Data, Databases and Systems Complexity. Data is ubiquitous, the database universe is dichotomous (structured and unstructured), expanding and complex. Find my Database Research at SQLToolkit.co.uk . Microsoft Data Platform MVP

"The important thing is not to stop questioning. Curiosity has its own reason for existing" Einstein



Tuesday, 2 November 2010

The Database is Shutdown

When the databse state is showing as shutdown some troubleshooting steps are required.

To identify the database status run:-

USE master
SELECT databaseproperty(‘databasename’,'isShutdown’)

Clear the database status:-

USE master
ALTER DATABASE databasename SET offline

Bring the database back online:-

USE master
ALTER DATABASE databasename SET online

Check database

DBCC CHECKDB

Other things to check
  • Is Autogrow enabled?
  • Is their enough filespace?
  • Is their sufficient memory and disk space?
  • Are the physical files marked as read only?

No comments:

Post a comment

Note: only a member of this blog may post a comment.