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:
- Database administrator needs to add more hard drive space and it can be done by following methods:
- Remove the unnecessary files from the hard drive
- Add new hard drive.
- Check the Autogrow feature of the database, if it is ON then disable it.
- Have you enough permission to open the database? Check for the permission setting.
- 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