Home 2017 March SQL Server: fix error 945 database cannot be opened due to inaccessible files or insufficient memory or insufficient space on disk

SQL Server: fix error 945 database cannot be opened due to inaccessible files or insufficient memory or insufficient space on disk

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

“SQL Server error 945 database cannot be opened due to inaccessible files or insufficient memory or insufficient space on disk”

This error occurs when SQL Server can’t recover missing files or may be backup is corrupted. The effect of this error are, Database in suspected mode, Stop all the database transactions, Stop other operation of a database.

The possible solution are,

  • Remove unnecessary files from hard drive and free space of hard disk. If possible add new large size hard drive
  • Check the account permission
  • Database must set to Autogrowth
  • MDF and LDF files should not mark as read only
Anvesh Patel
SQL Server Interview: If Transaction Log Full, what are your steps to resolve itSQL Server Interview: Use DBCC SQLPERF to monitor the Transaction Log File Size for all Databases

Leave a Reply

CAPTCHA

*

Anvesh Patel
Anvesh Patel

Database Engineer

March 7, 2017 SQL Server, , , , , , , , , , , , , , , ,