SQLServer将数据库置为只读

将数据库置为只读

?

1 2 3 4 5

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

　　

取消只读

?

1 2 3 4 5

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