代碼: 選擇全部
RESTORE DATABASE [master] FROM DISK = N'master.bak' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 10
GO
RESTORE DATABASE [msdb] FROM DISK = N'msdb.bak' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 10
GO
代碼: 選擇全部
EXEC sp_configure 'allow updates', 1
reconfigure with override
GO
update msdb.dbo.syssubsystems
set subsystem_dll= replace(subsystem_dll,'D:Program Files','C:Program Files')
FROM msdb.dbo.syssubsystems
where subsystem_dll like 'D:Program Files%'
GO
EXEC sp_configure 'allow updates', 0
reconfigure with override
GO
-- ensure the change took
select subsystem, subsystem_dll, agent_exe
from msdb.dbo.syssubsystems
where subsystem_dll like 'c:Program Files%'
GO
代碼: 選擇全部
ALTER SERVICE MASTER KEY FORCE REGENERATE
GO