sqlserver 设置数据库恢复模式

Enterprise Edition 有三种恢复模式 FULL | BULK_LOGGED | SIMPLE

use master
go
alter database AdventureWorks
set RECOVERY FULL--完全
go

use master
go
alter database AdventureWorks
set RECOVERY SIMPLE--简单
go

use master
go
alter database AdventureWorks
set RECOVERY BULK_LOGGED --大容量
go

查看数据库当前的恢复模式

use master
go
select recovery_model_desc from sys.databases where name='AdventureWorks'
go