1.

net stop mssqlserver

2.

net start mssqlserver /m

3.

restore database master from disk='d:\master' with recovery

복원되면 자동으로 DB SERVER가 중지된다

4.

net start mssqlserver

5.  등등 기타 DB복원

restore database msdb from disk='d:\msdb' with recovery

6. 복원 잘됐는지 확인

use master
select * from sysservers
select * from sysdatabases
select * from sysusers
select * from sysxlogins
select @@servername

use msdb
select * from sysjobs
select * from sysjobschedules
select * from sysjobservers

7. 뭐 필요하다면 서버 이름 변경도 하고.....

update sysjobs set originating_server='DEVSVR'

sp_configure 'allow update', 1
reconfigure with override

update sysservers set srvname='DEVSVR', datasource='DEVSVR'

sp_configure 'allow update', 0
reconfigure with override

8. 마지막으로 다시하번..DB서버 재시작 해주면 좋고

net stop mssqlserver
net start messqlserver