--该重建日志方法来自微软技术支持
alter database dbname set emergency
go
alter database dbname set single_user with rollback immediate
go
use master
go
alter database dbname Rebuild Log on
(name=dbname_log,filename='D:\Log\dbname_log.LDF')
go
alter database dbname set multi_user