Msg 945, Level 14, State 2, Line 1
Database 'db' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server error log for details.
Got the above error message and i thought to shrinking of log will give solution. After shrink of log file I got one more error while accessing the database from management studio
Database 'db' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server error log for details.
So I tried with the following steps
1. check the DB status, most of the time , it will return 1
use master
select databaseproperty('dbname','isShutdown')
2. Change the database to offline to clear the db status
use master
alter database dbname set offline
3. Now change the database to online, at this step log file and data files will be verified by sql server
use master
alter database dbname set online
This solution solved the problem.
Database 'db' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server error log for details.
Got the above error message and i thought to shrinking of log will give solution. After shrink of log file I got one more error while accessing the database from management studio
Database 'db' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server error log for details.
So I tried with the following steps
1. check the DB status, most of the time , it will return 1
use master
select databaseproperty('dbname','isShutdown')
2. Change the database to offline to clear the db status
use master
alter database dbname set offline
3. Now change the database to online, at this step log file and data files will be verified by sql server
use master
alter database dbname set online
This solution solved the problem.
Post a Comment