The Log For the Database is Not Available
-
This error occurs frequently and no insert query is running. if i restart the sql server services it is working fine,but often getting this error message. Recently i changed my management studio to 2012 as my server is 2008 R2 version.How to fix this issue permanently?
-
This error occurs frequently and no insert query is running. if i restart the sql server services it is working fine,but often getting this error message. Recently i changed my management studio to 2012 as my server is 2008 R2 version.How to fix this issue permanently?
Hi, Usually it's because there are corruption problems related to the storage system. Have you tried running DBCC CHECKDB against the database?
DBCC CHECKDB ('Your DB Name') WITH NO_INFOMSGS;
GOThis could give you more information. Also, check the Auto Close property:
SELECT DATABASEPROPERTY ('Your DB Name', 'IsAutoClose');
GOIf it returns 1 (Auto Close is on), then that may be the reason of your problem...
Regards, Andrius Leonavicius
-
This error occurs frequently and no insert query is running. if i restart the sql server services it is working fine,but often getting this error message. Recently i changed my management studio to 2012 as my server is 2008 R2 version.How to fix this issue permanently?
The Log For the Database is Not Available[^] And please, do not post your question all over the place...
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
-
Hi, Usually it's because there are corruption problems related to the storage system. Have you tried running DBCC CHECKDB against the database?
DBCC CHECKDB ('Your DB Name') WITH NO_INFOMSGS;
GOThis could give you more information. Also, check the Auto Close property:
SELECT DATABASEPROPERTY ('Your DB Name', 'IsAutoClose');
GOIf it returns 1 (Auto Close is on), then that may be the reason of your problem...
Regards, Andrius Leonavicius
Dear Sir, It shows the following error 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. my database shows is_auto_close_on=1. What i should do to solve this?
-
Dear Sir, It shows the following error 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. my database shows is_auto_close_on=1. What i should do to solve this?
I'd recommend to turn off the Auto Close:
ALTER DATABASE database_name
SET AUTO_CLOSE OFF;
GOSpeaking about errors, try to restart the server and run DBCC CHECKDB again. Also, take a look at Windows Event Logs for errors. BTW, do you have enough disk space?
Regards, Andrius Leonavicius
