Monday, February 25, 2013

Help Me! I am unable to open my SQL server database

At times, when SQL server database administrator tries to open the database, he gets below error message on the screen.

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

Cause: As the result of above error message, database administrator is unable to open the database. There are various reasons for the above error message like less disk space, permission unavailability and many more.

It is one of the most generated error message during mounting the SQL sever database.

WorkAround: Database administrator can resolve above error message by following steps:
  1. Database administrator needs to add more hard drive space and it can be done by following methods:
    1. Remove the unnecessary files from the hard drive
    2. Add new hard drive.
  2. Check the Autogrow feature of the database, if it is ON then disable it.
  3. Have you enough permission to open the database? Check for the permission setting.
  4. Check for .mdf & .ldf files. If these files are mark as read only then database administrator is unable to open the file.

No comments:

Post a Comment