Main menu

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 Msg 945, Level 14, State 2, Line 1 Database ‘database’ cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.

1) It’s looks like It’s an disk memory issue so check space first.

2) Check if current user having permission

3) Check if database AutoGrow is enable.

4) Check if you enabled the compression on Database partition.

5) Check if database is currently online.

use master
select databaseproperty('dbname','isShutdown')

If it’s return 1 follow the make it online

use master
alter database dbname set offline
alter database dbname set online

 

 

FacebookTwitterGoogle+RSS