SQLServer将数据库置为只读

将数据库置为只读

use [master]

go
alter database [database-name] set read_only with no_wait;
go

　　

取消只读

use [master]
go

alter database [database-name] set read_write with no_wait;
go