Sql Server 压缩数据库日志文件的方法(压缩sql日志文件步骤是什么)深度揭秘

随心笔谈12个月前发布 admin
98 0

use [master]
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

© 版权声明

相关文章