Restoring SQL Jobs

  • Does anyone know how to restore SQL 7.0 scheduled jobs. SQL Server crashed and after i restored the database the sheduled jobs were lost. The person who set this up did not script the jobs. Please help, I have a copy of the msdb.

  • Sheduled jobs are in the MSDB database.

    You should be able to restore the MSDB database.

    I think you'll have to stop SQLAgent before you try and restore MSDB.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply