直接上腳本了
--檢查數(shù)據(jù)庫
DBCC CHECKDB (JiangsuMobileOA) WITH PHYSICAL_ONLY
--查看文件位置以及數(shù)據(jù)庫的狀態(tài)
SELECT name, physical_name AS CurrentLocation, state_desc FROM sys.master_files
--將鏡像進(jìn)行掛起操作,停止鏡像(如果有設(shè)置的話)
--ALTER DATABASE JiangsuMobileOA SET PARTNER SUSPEND
ALTER DATABASE JiangsuMobileOA SET OFFLINE
--修改數(shù)據(jù)文件的位置
alter database JiangsuMobileOA modify file(name=JiangsuMobileOA,filename='E:\SqlServer\DATA\JiangsuMobileOA.mdf')
alter database JiangsuMobileOA modify file(name=JiangsuMobileOA_log,filename='E:\SqlServer\DATA\JiangsuMobileOA_log.ldf')
--啟動鏡像
ALTER DATABASE JiangsuMobileOA SET ONLINE
--ALTER DATABASE JiangsuMobileOA SET PARTNER RESUME
--再次檢查數(shù)據(jù)庫
DBCC CHECKDB (JiangsuMobileOA) WITH PHYSICAL_ONLY