use [master]
go
alter database [dbname] set recovery simple with no_wait
go
alter database [dbname] set recovery simple
go
go
alter database [dbname] set recovery simple with no_wait
go
alter database [dbname] set recovery simple
go
use [dbname]
go
dbcc shrinkfile (N’dblogname’,11,truncateonly)
go
use [master]
go
alter database [dbname] set recovery full with no_wait
go
alter database [dbname] set recovery full
go
© 版权声明
文章版权归作者所有,未经允许请勿转载。