Hi, In the event of a system crash, whereby the whole server had to be
re-built, how would I best restore the msdb database, in order to restore
all DTS's which I had?

Hi Ben,

Please read the following article and you will find answers
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071

HTH
Andreas



Show quoteHide quote

Ben:

You can simply restore msdb from a backup that you have made as long as no
one is using it.  That really means to just stop the SQL Server Agent
process and restore the database and then start the Agent back up.  Works
like a champ (I actually had to do it this weekend due to a server failure).
One issue though is to remember to press your F5 key to refresh your view in
EM or you may end up giving yourself an unnecessary heart attack.

See the following if you want/need it straight from Microsoft:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_2w1f.asp

Scott

Show quoteHide quote

multiple records update kills trigger .. please help
Permssion denied for dbo
Sql Server 2000 administration
Audit in SQL Server
Password Error... while installing SQL SP 3a
Managing XML field with Enterprise Manager
Does anyone know if guest account must be enabled?
Separating data and indexes
SQL performance
Sql Server Performance Monitoring Logs