The Log For the Database is Not Available

Question

0.00/5 (No votes)

See more:

This error message occurs when i perform any execute alter or insert statement in sql server.
After restarting the sql server services it is working fine,but often getting this issue.
Suggest me permanent solution.

Actually i installed Sql server 2012 management studio in my system and i am using 2008 R2 as server as this error comes after changing the Management studio.

How to recover from this issue.provide me permanent solution...

Posted 19-Jul-14 1:07am

Prakash S

Add a Solution

Comments

Prakash S 21-Jul-14 2:41am

After checking DBCC checkdb('') .the below error comes

Msg 1823, Level 16, State 2, Line 1
A database snapshot cannot be created because it failed to start.
Msg 7928, Level 16, State 1, Line 1
The database snapshot for online checks could not be created. Either the reason
is given in a previous error or one of the underlying volumes does not
support sparse files or alternate streams. Attempting to get exclusive access to run checks offline.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kornfeld Eliyahu Peter · Answer 1 · 2014-07-19T22:03:00

Solution 1

1. Detach database files
2. Attach database files
3. Run DBCC checkdb for errors...

Posted 19-Jul-14 22:03pm

Kornfeld Eliyahu Peter

Comments

Prakash S 21-Jul-14 2:02am

i have checked with your solution it shows no error messages.Now the same problem leads to other database's which i have been using in the same sever..

Kornfeld Eliyahu Peter 21-Jul-14 2:05am

If you got the error on different DBs you should check your hardware...

Prakash S 22-Jul-14 7:38am

After checking DBCC checkdb('') .the below error comes

Msg 1823, Level 16, State 2, Line 1
A database snapshot cannot be created because it failed to start.
Msg 7928, Level 16, State 1, Line 1
The database snapshot for online checks could not be created. Either the reason
is given in a previous error or one of the underlying volumes does not
support sparse files or alternate streams. Attempting to get exclusive access to run checks offline.

Kornfeld Eliyahu Peter 22-Jul-14 7:51am

According to Microsoft one of the main reasons is "The database contains at least one file group that is marked as read-only." - check it...
Also read this: http://sqlservermct.wordpress.com/2012/02/01/error-message-a-database-snapshot-cannot-be-created-because-it-failed-to-start-when-running-dbcc/