USE master
ALTER DATABASE [KH2020] SET OFFLINE WITH ROLLBACK IMMEDIATE
RESTORE database [KH2020] from disk=‘D:\客户数据\HHerp_lgyy202108231053\HHerp_lgyy202108231053.bak‘ with RECOVERY,REPLACE
ALTER database [KH2020] set online
USE KH2020
原文：https://www.cnblogs.com/yyl001/p/15206530.html