SQL Tutorials

SQL SERVER – FIX : Error 945 Database cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server error log for details

SQL SERVER – FIX : Error 945 Database cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server error log for details.

Description:

This error is very common in Sql database servers.While access the database or database resoreing it will not written the log files result it will give the below error,

Error 945 Database cannot be opened due to inaccessible

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

Solutions:

– Before start the additional steps check the disk space of the sql installed drive.If it is less increase the drive size.check the memory utilization also.Increase the memory(Ram).

– Now verify is database set Autogrow on.

– Check the database user name assign properly if assign check the user permission for the database.

– In sql installed directory verify the .mdf and .ldf file permissions.

Follow the above steps to resolve the issue.

Tags:Sql,SQl 2000,SQl 2005 Installation,SQL 2008 errors,SQL database restore.