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

"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.