restoring msdb

• jing Farrell

  Old Hand

  Points: 316

  More actions

  September 15, 2004 at 2:58 am

  #112436

  Hi All,

  I have mistakenly deleted latest verions of DTS packages instead of the oldest versions on our server .

  Could anyone know whether  I could restore sysdtspackges table of MSDB from a backup copy to get the latest versions back?

   

  Thank you very

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  September 16, 2004 at 9:15 am

  #523360

  That's why you backup the system databases.  You can't restore a single table, but you can restore the entire database.  See "Resoring msdb database" in BOL for details.

  Greg

  Greg

• jing Farrell

  Old Hand

  Points: 316

  More actions

  September 16, 2004 at 9:21 am

  #523362

  Hi Greg

  Thank you for your advice. I restored whole msdb copy to  the standby server ( nothing on it). and then use query:

  insert into msdb.dbo.sysdtspackges

  select * from standbyservername.msdb.dbo.sysdtspackges

  It seems working fine.

   

  Thank you very much.