Saturday, October 17, 2009

Error 945 Database Cannot Be Opened Due To Inaccessible Files or Insufficient Memory or Disk Space

Error 945 Database cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server error log for details.

This error is very common for any database administrator who are handling more databases in a single instance. It will leads to suspect the database most of the time. 

Fix / Solution:
Step 1: if the drive is specifically assigned to Log Files and Log drive was full, clear the drive space by shrinking the log space of other databases which occupied more log space. 
Step 2: ALTER DATABASE [Database name] SET ONLINE 
Step 3: If possible add more drive space by adding new hard drive to server. 
Step 4: Increase the Database log size to more or set to Unlimited grow. 
Step 5: Find out if the account which is trying to access the database has enough permission to access the database. 
Step 6: Configure one maintenance job for backup log.



Database cannot be opened, unable to open database, due to inaccessible files. insufficient memory. SQL server database cannot open, sql server inaccessible files, sql server insufficient memory. Msg 945, Level 14, State 2, Line 1 Database cannot be opened. Error 945 Database cannot be opened due to inaccessible files. Error 945 Database cannot be opened due to inaccessible files or insufficient memory or disk space

0 comments:

Post a Comment