Database Restores

• ChiragNS

  One Orange Chip

  Points: 26137

  More actions

  November 30, 2006 at 9:32 pm

  #115195

  hi

  i have made a number of restores to various database on my server, but the restore history tables restorehistory,restorefilegroup and restorefile do not contain any records at all.

  Any idea as to whats going on

  Thanks In Advance

  "Keep Trying"

• MohammedU

  SSCoach

  Points: 19644

  More actions

  December 1, 2006 at 1:27 pm

  #675272

  Are you using History Cleanup task in your Maint.  plans?

  If yes...check..

  http://msdn2.microsoft.com/en-US/library/ms139794.aspx

  MohammedU

  MohammedU
  Microsoft SQL Server MVP

• MohammedU

  SSCoach

  Points: 19644

  More actions

  December 1, 2006 at 1:27 pm

  #675270

  Are you using History Cleanup task in your Maint.  plans?

  If yes...check..

  http://msdn2.microsoft.com/en-US/library/ms139794.aspx

  MohammedU

  MohammedU
  Microsoft SQL Server MVP

• ChiragNS

  One Orange Chip

  Points: 26137

  More actions

  December 3, 2006 at 11:52 pm

  #675396

  hi

  Thanks, that certainly was the case. Is there any method of getting backup and restore information even while using history cleanup task ?

  "Keep Trying"