Welcome to Management Pack Wiki! Your documentation pro for SCOM Management Packs
1 comment(s) Post a comment
  • Management Pack:  SQL Server
  • MP Version:  6.3
  • Released:  4/2/2012
  • Publisher:  Microsoft

Database cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details Rule

  • ID:  Microsoft.SQLServer.2005.Database_cannot_be_opened_due_to_inaccessible_files_or_insufficient_memory_or_disk_space._See_the_SQL_Server_errorlog_for_details_1_5_Rule
  • Description:   
  • Target:  SQL Server 2005 DB Engine
  • Enabled:  Yes

Overridable Parameters

Parameter Name Default Value Description Override
Priority 1  
Severity 1  

Run As Profiles

Name
SQL Server Default Action Account

Alert Details

Message Priority Severity
Database cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details Medium Warning

Rule Knowledgebase

Summary

Error 945 is returned when the database is marked IsShutdown. This occurs when a database cannot be recovered due to missing files, or some other resource error that usually can be corrected easily.

Causes
This rule does not contain any causes.
Resolutions

First, verify that the database is marked IsShutdown using DATABASEPROPERTY.

Then, determine the cause of the error by consulting the errorlog, and take action as noted below.

  • Make the files available and bring the database OFFLINE using ALTER DATABASE.

  • Use ALTER DATABASE to bring the database ONLINE

First, verify that the database is marked IsShutdown using DATABASEPROPERTY

Then, determine the cause of the error by consulting the errorlog, and take action as noted below.

If one or more data or log files are missing:

  • Make the files available and bring the database OFFLINE using ALTER DATABASE.

  • Use ALTER DATABASE to bring the database ONLINE.

If insufficient log space:

  • Use sp_add_log_file_recover_suspect_db() to add another log file

The database is recovered and brought online by this procedure.

If insufficient data space:

  • Use sp_add_data_file_recover_suspect_db() to add another log file

The database is recovered and brought online by this procedure.

If insufficient memory:

The insufficient memory error can occur when a number of databases are recovered at the same time. Retrying the operation may fix the problem:

  • Retry the operation using ALTER DATABASE to bring the database OFFLINE

  • Use ALTER DATABASE to bring the database ONLINE

If retrying the operation does not work, consider freeing up memory.

External References
This rule does not contain any external references.

See Also for SQL Server Management Pack


Downloads

Enrique
Posted : Saturday, June 28, 2014 10:10:17 AM(UTC)

Comments: 1

Due to over storage of SQL database files the memory allocation refuses and creates some errors which are responsible for SQL database inaccessibility. You must go through this to learn more about resolving solutions:- http://www.sqlrecoverysoftware.net/blog/sql-error-926-and-945.html
Post a comment
Comments to other elements of this Management Pack:
Article Message Posted By
Overview
We are providing a platform for those who want to join this profession.
writing jobs
jobs
shahid.afraid111@gmail.com at 10/29/2014 11:48:42 AM
Overview
Is Management Pack inventory available for SQL Server 2012 MP version 6.5.1.0?
milmanfm@gmail.com at 9/23/2014 11:36:42 AM
Database consistency errors found
I recommend you to read this article which serve you how get rid of this consistency error:- http://www.sqlrecoverysoftware.net/blog/fix-database-consistency-errors.html
elliswhite43@gmail.com at 5/10/2014 11:06:07 AM
Overview shantal@list.ru at 7/2/2013 11:57:28 AM
Overview
Where can i get the Management pack Inventory for SQL 2008
vivakhangloo@gmail.com at 4/4/2013 8:32:16 AM
Overview
According to the Pinpoint catalog, the SQL MP was updated to include SQL 2012 monitoring as of 4/2/2012. Do you have an ETA for when this MPwiki entry will be updated? Keep up the great work; thanks!
bdady@denaliai.com at 5/30/2012 2:47:22 PM
DB File Space
You should keep in mind that file-level monitoring works rather good now but in case of extremely loaded server (e.g. which works all the time about 99% of CPU) or you have really huge number of DBs and files (e.g. 500 databases consist of 1000-2000 files) - you should think about Database-level space monitoring.
legolasishe@mail.ru at 3/21/2012 1:39:09 PM
Overview shantal@list.ru at 11/4/2011 3:29:24 PM
Overview igrudina@viacode.com at 10/26/2011 4:12:53 PM