ALTER DATABASE A SET SINGLE_USER WITH ROLLBACK IMMEDIATE
ALTER DATABASE A MODIFY NAME = [B]
ALTER DATABASE B SET MULTI_USER
根据微软文档,我应该将数据库设置为single_user然后重命名。为什么?如果只是为了确保所有连接都关闭,这也可以工作:
ALTER DATABASE A SET OFFLINE WITH ROLLBACK IMMEDIATE
ALTER DATABASE A SET SINGLE_USER WITH ROLLBACK IMMEDIATE
ALTER DATABASE A MODIFY NAME = [B]
ALTER DATABASE B SET MULTI_USER
ALTER DATABASE A SET OFFLINE WITH ROLLBACK IMMEDIATE
WITH ROLLBACK NO_WAIT
可以确保其他操作没有潜在的数据丢失风险。 - LONG