数据备份还原

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

 

posted @ 2021-08-30 16:20  乌柒柒  阅读(33)  评论(0)  编辑  收藏  举报