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
