October 29, 2010 at 8:37 am
I was accessing all my database and one of them couldn't be accessed. I got the below error message
"Database 'TIN0650' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details."
Can Anyone help with resolving it?
October 29, 2010 at 8:40 am
Did you check the error log to find out for definite what exactly is the problem. It could be that you have ran out of Disk space.
-Roy
October 29, 2010 at 10:02 am
mashikoo (10/29/2010)
"Database 'TIN0650' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details."
So what details were in the SQL error log?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 29, 2010 at 10:12 am
Thanks guys. I took the database offline and brought it back online below are the steps I followed:
STEP1: identify the db status:
use master
select databaseproperty(‘db_name’,'isShutdown’)
Most of them it would return 1 in this situation
STEP2: Clear up the internal db status:
use master
alter database db_name set offline
it would return with no error in most cases
STEP3: Get detail error message:
use master
alter database db_name set online
After step3, sql server will first verify the log file, if the log file is okay, it will verify the rest of the data file(s). Most of time it is because of the file location or file properties setting. For example if it is file location issue:
alter database db_name
modify (file=’logical name’, filename=’physical name’)
go
October 29, 2010 at 2:34 pm
October 29, 2010 at 2:46 pm
pavan_srirangam (10/29/2010)
May you don't have the permission to that particular database.
Lack of SQL permissions would not cause this. This is an error from SQL saying that it cannot, for some reason, access one or more of its database files.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply