August 18, 2012 at 3:49 pm
Hi,
I am getting the below error error message.
The log for database 'Commun' is not available. Check the event log for related error messages. Resolve any errors and restart the database.
when i ran the dbcc check command it is giving the below error message.
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.
Msg 5030, Level 16, State 12, Line 1
The database could not be exclusively locked to perform the operation.
Msg 7926, Level 16, State 1, Line 1
Check statement aborted. The database could not be checked as a database snapshot could not be created and the database or table could not be locked. See Books Online for details of when this behavior is expected and what workarounds exist. Also see previous errors for more details.
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.
Msg 5030, Level 16, State 12, Line 1
The database could not be exclusively locked to perform the operation.
Msg 7926, Level 16, State 1, Line 1
Check statement aborted. The database could not be checked as a database snapshot could not be created and the database or table could not be locked. See Books Online for details of when this behavior is expected and what workarounds exist. Also see previous errors for more details.
Msg 9001, Level 21, State 1, Line 1
The log for database 'Commun' is not available. Check the event log for related error messages. Resolve any errors and restart the database.
can anyone please help me
Thank You,
August 18, 2012 at 3:56 pm
Are there any earlier error messages?
Is the log file present where it should be? Is the drive online, etc? What's the state of the database?
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
August 18, 2012 at 11:48 pm
First and foremost if this is a production database look for a proper downtime window.
Also attempt a database backup before trying out anything, but that may fail again.
as a first step you can try this ;
execute the following command
use <databasename>
go
This will change the database context, then execute
sp_helpfile
go
Then note down the location of the log file from the sp_helpfile output
Then search if the file exists physically in the file system.
if the file exists than you can try detaching the database, you will still get an error during detach but the database will be detached.
to be on the safer side you can also backup the database files after they are detached.
and then you can attempt attachign the database files again.
Hope you do not have to go through the service restart to resolve the issue.
Good Luck.
August 19, 2012 at 1:12 am
You've seen the message:
The log for database 'Commun' is not available. Check the event log for related error messages. Resolve any errors and restart the database.
it says ...check the eventlog...
I would take a look at the sqlserver errorlog file and search for messages related to that db.
Keep in mind you may need to search more than one copy of the errorlog.
(errorlog.1, errorlog.2,...)
Post your findings and we may be able to help out further.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
August 20, 2012 at 9:38 am
Hi,
This is the error log message before that issue happened.
Transaction (Process ID 12) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Thank You,
August 20, 2012 at 9:47 am
That's not interesting (and shouldn't be in the SQL error log anyway)
Is the log file present where it should be? Is the drive online, etc? What's the state of the database?
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
August 20, 2012 at 9:49 am
Hi,
The log file for the database is present and the drive is online on the server.
Log files of other databases are present on the same drives and they run without any issues on the server
The status of the database is online and log_reuse_wait_desc is database_snapshot_creation
Thank You
August 20, 2012 at 9:53 am
Hi
The Log file of the database is present where it is supposed to be.The drive on which the log file is present is online.
Thank You,
August 20, 2012 at 9:54 am
Ok, so what's the problem? Was it just in running CheckDB?
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
August 20, 2012 at 9:56 am
Hi ,
The required information is present in the current SQL Server Error Log.
It is not present in the Archive #1 SQL Server Error Log.
Information related to this Log file is not found in the Error Logs.
Thank You,
August 20, 2012 at 10:00 am
Hi,
CHECKDB is running for that database through out the day every few minutes.
There is no job associated with the checkdb to run through out the day. I think vendor is running that.
Thank You,
August 20, 2012 at 10:39 am
Are you sure CheckDB is running, not just a message saying when it last ran?
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
August 20, 2012 at 12:59 pm
Backups are failing for that database and integrity checks are not running successfully for that database
August 20, 2012 at 1:01 pm
Errors please.
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
August 20, 2012 at 2:31 pm
Hi ,
Below is the error message when we are running the backup of the commun database.
Date8/19/2012 11:15:00 PM
LogJob History (DatabaseBackup - Commun - FULL)
Step ID1
Servertest
Job NameDatabaseBackup - Commun - FULL
Step NameDatabaseBackup - Commun - FULL
Duration00:00:00
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
Msg 9001, Level 21, State 1, Server test, Line 1
The log for database 'Commun' is not available. Check the event log for related error messages. Resolve any errors and restart the database.
Msg 3013, Level 16, State 1, Server test, Line 1
BACKUP DATABASE is terminating abnormally.
Thank You,
Viewing 15 posts - 1 through 15 (of 22 total)
You must be logged in to reply to this topic. Login to reply