Database cannot be opened due to inaccessible files or insufficient memory or disk space
Database cannot be opened due to inaccessible files or insufficient memory or disk space
Recently, this error made my website down for two days. In order to solve this issue, I tried many things and came up with the following solutions to fix up this error:
1) This issue may be caused if the database is stuck in recovery mode. This may occur due to power failure, insufficient memory, insufficient disk space, wrong drive location, Stopped transactions etc. For the first case, restarting the sql server service or restarting the computer would work.
2) Make sure the sql server restore and backup file location is valid and correct. If the path is not correct, sql server is not able to find out the backup file and hence is stuck in recovery mode. Set the right location and make the db offline then online to fix this issue.
3) Many third party or sql server patches may stop the restore process of sql server. Make sure the third party software or sql server upgrade is not obstructing the recovery process of sql server.
4) Check for hard disk space on the disk where the mdf file is stored. It’s recommendable to keep at least 2-5 GB of free space. Free hard disk space by removing unnecessary files or make your sql server store data in new partition. Optionally, you may shrink the log and data file. To do so, right click databse and select Task -> Shrink - > Database and press ok button. Same can be done by using the shrink file command as
USE [DatabaseName]
DBCC SHRINKFILE('DatabaseName_Log',7)
5) This issue may occur due to insufficient permissions or user rights. Normally in a business environment, password expires every 2-3 month. Check if the username-password combo used for backup or restore operation is valid and up to date. Check the account accessing database has the required permission to do so.
6) Right click .mdf and .ldf file and click properties to see if the file is not read only. Sometimes the accidental operation or power failure makes the file read only.
7) Make sure database Autogrow property is set on.
Note: Images used on this website
are either a production of Bhaktivedanta Book Trust(https://www.krishna.com), Iskcon
Foundation or were found in google search under "Free to use and share". If any
of the images presented here violates copyright issues or infringes anyone copyright
or are not under "Fair use", then please bring it to our notice. Read
Disclaimer for more.
Share this to your friends. One of your friend is
waiting for your share.
Related Articles
How AJAX Works, advantages and disadvantages
Working with AJAX cascading dropdown
Call .net service from javascript
Visitors-Hits counter for your website
Bhagavad gita Chapter1, verse 3 english and hindi poetic translation with lessons
Testing performance issues with reflection
Binding Database columns with apostrophe
Show Update Progress Animation-Ajax
How to encode and decode HTML request in ASP.NET
Increase performance of your website using caching
Post Comment