例子,查询sql数据库中恢复模式的sql语句:
复制代码 代码示例:
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