restore msdb

hi, all
how to resotore msdb
thansks
Hi,
1. Stop the SQL Agent service
2. Execute the below command to set the databse to sinle user and restore.
Alter database msdb set single_user with rollback immediate
go
restore database msdb from disk='c:\backup\msdb_backup.bak'
go
Alter database msdb set multi_user with rollback immediate
3. If you are restoring the MSDB from a differnt server you need to update
the SYSJOBS table wth current sql server name,
Because the servername in the table will be source server and all the jobs
will fail.
How to update:-
UPDATE MSDB..SYSJOBS
SET Originating Server = @.@.Servername
WHERE Originating Server <> @.@.Servername
4. start sql agent service
Thanks
Hari
MCDBA
"metoonyc" <metoonyc@.yahoo.com> wrote in message
news:eH75WUSSEHA.3968@.TK2MSFTNGP09.phx.gbl...
> hi, all
> how to resotore msdb
> thansks
>