Windows / 数据库 · 2012-11-29

sql 2008 清除日志脚本

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

use master
go
 
ALTER DATABASE [edupress.news] SET RECOVERY SIMPLE WITH NO_WAIT
 
use [edupress.news]
go
select name from sys.database_files
where type_desc = 'log'
 
DBCC SHRINKFILE([shedunews_log], 1)
 
USE [master]
GO
ALTER DATABASE [edupress.news] SET RECOVERY FULL WITH NO_WAIT

标签：