Hello Everyone,
I have SQL Server Express Edition on my server (Windows Server 2008 R2). And have a database for my website on it.
My database stopped working today. The error which my website showing was like this:
Login failed to database 'mydatabase' .... from the user 'user1' ...
I am sorry I forgot to copy that error.
At first, to see the reason for the issue I opened the "SQL Management Studio" and found that the database was there but it was not extendable and when I tried to open its properties, I got this error:
Database 'mydatabase' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details. (Microsoft SQL Server, Error: 945)
The space on my disk is approx 60GB, so I was sure that disk space is not the issue.
So I reviewed the log and I found this error message:
FC ...
Go to the complete details ...