首先关闭数据库服务,找到log文件删除掉,再打开数据库服务,执行下面代码即可
use master
go
alter database DataBaseName set emergency
go
alter database DataBaseName set single_user with rollback immediate
go
use master
go
alter database DataBaseName Rebuild Log on
(name= DataBaseName _log,filename='C:/Program Files/Microsoft SQL Server/MSSQL10.MSSQLSERVER/MSSQL/DATA/ DataBaseName _log.LDF')
go
alter database DataBaseName set multi_user