--
该重建日志方法来自微软技术支持
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:Logdbname_log.LDF ' )
go
alter database dbname set multi_user[@more@]
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:Logdbname_log.LDF ' )
go
alter database dbname set multi_user[@more@]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7192349/viewspace-1029574/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7192349/viewspace-1029574/