Tuesday, 4 March 2014

Database cannot be opened due to inaccessible files or insufficient memory or disk space

sqltrends.blogspot.in/2013/03/database-cannot-be-opened-due-to.html
Here is Solution/Fix/workaround of this problem.

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.

No comments:

Post a Comment