Search Mallstuffs

Flag Counter
Spirituality, Knowledge and Entertainment




Latest Articles


Move to top
Database cannot be opened due to inaccessible files or insufficient memory or disk space
Posted By Sarin on Nov 16, 2012     RSS Feeds     Latest Hinduism news
2474 Views

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(http://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
Visitors-Hits counter for your website
Binding Database columns with apostrophe
Call .net service from javascript
Working with server controls and HMTL controls
How to encode and decode HTML request in ASP.NET
Testing performance issues with reflection
Bhagavad gita Chapter1, verse 3 english and hindi poetic translation with lessons
Calling web service asynchronously using jquery ajax
Create property class of database table
Database cannot be opened due to inaccessible files or insufficient memory or disk space

Post Comment




Software developer by profession,
Poet by hobby,
Blogger by Passion
Birth Place: Munger, Bihar
Residence: Mumbai, Maharashtra
Prof exp: 8 years

Read More about me

Read my daily what'sapp quotes
Most Viewed Articles

Latest Spiritual Videos


Latest Funny Videos

Latest News

Latest Social Post
Latest WhatsApp Quotes