The log cannot be rebuilt because there were open transactions/users when the database was shutdown, no checkpoint occurred to the database, or the database was read-only. This error could occur if the transaction log file was manually deleted or lost due to a hardware or environment failure.

The log cannot be rebuilt because there were open transactions/users when the database was shutdown, no checkpoint occurred to the database, or the database was read-only. This error could occur if the transaction log file was manually deleted or lost due to a hardware or environment failure.


Bir database'e ait log file'ı kaybettiğiniz de yada, sql server ilginç olarak elinizdeki database log file'ını tanımıyorsa.

Sql servislerini restart ettiğiniz halde log file oluşmamış ve database ulaşılmaz durumda ise aşağıdaki scriptler işinize yarayacaktır.

 
ALTER DATABASE  DB_name  SET EMERGENCY

select name,state,state_desc from sys.databases
where  name='DB_name'


ALTER DATABASE  DB_name SET SINGLE_USER WITH ROLLBACK IMMEDIATE


DBCC CHECKDB('DB_name',REPAIR_ALLOW_DATA_LOSS)

select name,state,state_desc from sys.databases
where  name='DB_name'


ALTER DATABASE DB_name  SET MULTI_USER